Copying and pasting

  • Thread starter Thread starter Jo C
  • Start date Start date
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
 
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
 
Back
Top