Paste w/o Hidden Cells

  • Thread starter Thread starter Eric F
  • Start date Start date
E

Eric F

I want to copy a sheet and paste to a new sheet without bringing over the
hidden cells and columns. Is there a way to do this with limited steps?
 
Hi
try the following
- hit F5 on your source sheet
- click 'Special' and choose 'only visible cells'. Hit OK
- hit CTRL+C to copy these cells
- insert them on your target sheet
 
Eric,

Should be very easy. Once you have selected the area you
want to copy, hit ALT + ; (semicolon). That should select
only visible cells. Now you can copy those cells and
paste them on your new worksheet.

Eric
 
Back
Top