Copying and pasting

J

Jo C

I need to know how to copy a spreadsheet with hidden cells. When I do
not want to copy the hidden cells to the new sheet. Plese help . Thanks
Jo C
 
B

Bob Umlas

Select all the cells you want to copy (including the hidden ones), then use
Edit/Goto, click Special, click Visible cells, then click OK, THEN
Edit/Copy, and then select the destination and paste.

Bob Umlas
Excel MVP
 
Top