| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy certain columns from one worksheet to another
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!!!! |
|
#2
|
|||
|
|||
|
Click the first column then hold down Ctrl and click the rest of them,
release Ctrl and copy/paste as normal, Regards, Alan, "Donna Dingle" <Donna wrote in message ... 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!!!! |
|
#3
|
|||
|
|||
|
Select the column headers with the Ctrl key down
Ctrl-C Go to the other sheet Ctrl-V -- Regards Ron de Bruin http://www.rondebruin.nl "Donna Dingle" <Donna wrote in message ... 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!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy worksheet to another worksheet | Excel Worksheet Functions | |||
| How do I copy a worksheet without the link to the original workboo | Excel Discussion (Misc queries) | |||
| Simple Copy from Worksheet to Worksheet | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
Linear Mode
