Hiding columns- copying and pasting

  • Thread starter Thread starter DaveSlinger
  • Start date Start date
D

DaveSlinger

I need to copy and paste certain worksheet columns into other programs
or into a new worksheet.

When I hide the columns that I don't want, drag and highlight (select)
the columns that I do want to copy, all of the hidden columns also
paste into the new worksheet.

Do I have to manually select, copy and paste each column separately?
 
One way:

Select your columns (including the hidden ones). Choose
Edit/Goto/Special and select Visible cells only. Copy. Paste - only
the visible columns will paste.
 
When I copied to another program (Notepad), only the visible cells were pasted.

But when I copied to another worksheet, I got the hidden columns.

One way around it is to just copy the visible cells.

Select your range
F5 (or edit|goto)
special
Visible cells only
edit|copy

and paste where you want.
 
Back
Top