Copy/Paste with Hidden Rows/Columns Excel 2007

  • Thread starter Thread starter Jayne Mae
  • Start date Start date
J

Jayne Mae

I am working with rather large & detailed spreadsheets. I have hidden rows
and columns with supporting details that feed into the viewable results
(formulas).
I need to take the “zipped up†data and copy/paste to a new worksheet. When
I paste the data, it appears with all of the hidden columns and rows visible
one again.
Is there any way to paste the zipped up data without the reappearance of the
previously hidden rows and columns?
Can you paste a link without all of the hidden data reappearing?
 
Select range to copy which includes hidden rows and columns.

F5>Special>Visible cells only>OK

Copy then paste to new worksheet.


Gord Dibben MS Excel MVP
 
I am working with rather large & detailed spreadsheets. I have hidden rows
and columns with supporting details that feed into the viewable results
(formulas).
I need to take the “zipped up†data and copy/paste to a new worksheet. When
I paste the data, it appears with all of the hidden columns and rows visible
one again.
Is there any way to paste the zipped up data without the reappearance of the
previously hidden rows and columns?
Can you paste a link without all of the hidden data reappearing?
Click to expand...
 
Thank you both! I SINCERELY appreciate your responses! You have just saved me
a headache and tons of work. :-)
 
Back
Top