Question: how to copy the whole column in excel?
Answer: To move rows or columns, on the Home tab, in the Clipboard group, click Cut . Keyboard shortcut: Press CTRL+X.
To copy rows or columns, on the Home tab, in the Clipboard group, click Copy . Keyboard shortcut: Press CTRL+C.