Copy/Paste with Hidden Rows/Columns Excel 2007

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

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
 
G

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?
Click to expand...
 
J

Jayne Mae

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste with hidden columns remaining hidden 2
Not include hidden columns in copy paste 2
Copy, paste 2
copying one column with hidden/filtered rows to another colum 2
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
How do I copy only the unhidden rows/colums? 2
copy outlined data in excel 1
copy/paste with hidden rows don't want hidden parts to paste 1

Top