copy a page with hidden rows and only paste what is showing

G

Guest

I am trying to find out how to copy an excel spreadsheet with hidden rows and
paste onto another sheet only what is showing so I do not have to continually
deal with the hidden rows.
 
G

Gord Dibben

Select the range then F5>Special>Visible cells only>OK

Copy then paste.


Gord Dibben MS Excel MVP
 

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/Paste with Hidden Rows/Columns Excel 2007 3
copy/paste with hidden rows don't want hidden parts to paste 1
copying one column with hidden/filtered rows to another colum 2
Copy and Paste with hidden columns remaining hidden 2
paste special 3
how do i copy/paste in excel without pasting hidden lines 1
Copy and Paste 2
paste excel sheet excluding hidden rows 3

Top