how do i copy and paste an entire column in excel?
['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.']