How do I NOT copy hidden rows to a new worksheet?

G

Guest

I have a large spreadsheet and have hidden rows. I do not want to copy the
hidden rows into a new spreadsheet. How do I do that?
 
G

Guest

After selecting, and before copying, use Edit->Goto->Special and click
Visible Cells Only, followed by OK. Now you can copy and paste as you wish
 

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

paste special 3
Copy/Paste with Hidden Rows/Columns Excel 2007 3
how do i copy/paste in excel without pasting hidden lines 1
Cannot unhide the hidden rows in my spreadsheet 3
How do I display a list of the rows or columns that I've hidden? 1
only count designated rows 3
Expand and Shrink Rows and columns to hide information. 1
Copy and Paste with hidden columns remaining hidden 2

Top