Question

You want to copy the contents of non- adjacent columns A,C and E. How can he select multiple non columns at one go?

Answer 1

Answer: Keep the Ctrl button pressed as you select the cells and copy. Then you can paste it anywhere else. The contents will appear in a single row or column

Explanation: You can only do this if all the cells are from the same column or row.