Omitting hidden columns when copying a range from a worksheet

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I have a worksheet with numerous hidden columns and rows. I would like to
copy the visible cells to a new worksheet, omitting the hidden cells.
However, using cut and paste or paste special I always get the hidden cells
copied as well. Is there a way round this?

Alternatively, is there a quick way of deleting all hidden rows & columns,
which would allow me to achieve the same thing if I copy the whole worksheet
and then delete hidden rows & columns?
 
After you've selected your range with the hidden rows/columns, hit Edit|goto (or
F5 or ctrl-G) and the click special, then select Visible cells only.

Now copy|paste.
 
Back
Top