Copy/Paste with Hidden Rows/Columns Excel 2007

[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?

 

[Gord Dibben]

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

 

[Gilbert]

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?

 

[Jayne Mae]

Thank you both! I SINCERELY appreciate your responses! You have just saved me
a headache and tons of work.