Copy certain columns from one worksheet to another

D

Donna Dingle

I wan to copy only certain columns from one worksheet to another without
having to delete the extra column information I do not need - does anyone
know how to do this it is driving me insane!!!!
 
A

Alan

Click the first column then hold down Ctrl and click the rest of them,
release Ctrl and copy/paste as normal,
Regards,
Alan,
 
R

Ron de Bruin

Select the column headers with the Ctrl key down

Ctrl-C
Go to the other sheet
Ctrl-V
 
Top