It's easy to copy a column of values in Excel using the keyboard.
- Select the column and the adjacent column. If the column of values is already selected, you can press [Ctrl]+[Shift]+[Right Arrow] to extend the selection.
- With both columns highlighted, press [Ctrl]+[Shift]+. (that's the period character).