Question: how to copy all values in a column in excel?
Answer: Select the cell that contains the format you want to copy.
Press [Ctrl]+C to copy the cell's content and formats.
Press [Ctrl]+Spacebar to select the entire column. Or press [Shift]+Spacebar to select the entire row. ... 
Choose Paste Special from the Edit menu.
Click Formats in the Paste Special dialog box and click OK.