Question: how to copy and paste a whole column on 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.