Copying only unhidden rows

G

Guest

Hi there

Is it possible to only copy unhidden rows? I have spent ages hiding rows so
that only sub total amount appears, but when I copy into a new sheet all the
hidden rows copy at the same time :-(

thanks

Cathy
 
G

Guest

Select the range of rows you want,(including hidden rows)
edit-goto-special-Select visible cells only
 
G

Guest

Select the area with the visible and hidden rows and tap F5.

Click special and select visible cells only and then Ctrl+c

Go the your new range and Ctrl+V

Mike
 

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

How do I copy only the unhidden rows/colums? 2
My rows keep "unhiding" when I do not want them to 6
Excel- Saving only unhidden rows 2
Pasting current view 1
How do I copy & paste only the unhidden data on a worksheet ? 1
Expand and collapse rows 7
How do I avoid copying data from hidden rows/columns? 2
code failing in hidden rows 16

Top