Excel- Saving only unhidden rows

G

Guest

Have received a spreadsheet the contains many hidden rows. I want to save it
with only the unhidden rows. Have tried Save Special-Values without success.
How can I save only the unhidden rows.
 
G

Guest

Hi
I think you will have to copy visible rows only to new spreadsheet and save
that
to do this
select edit goto special tick visible cells only
then copy and paste on new sheet or spreadsheet
Tina
 
T

Tom Ogilvy

you have to copy the cells to a new worksheet and save that.

Select all the cells and do edit-=>goto Special, then do edit=>Copy and go
to a new workbook, new sheet and select A1, then do edit=>Paste
 

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
Copying only unhidden rows 2
My rows keep "unhiding" when I do not want them to 6
Expand and collapse rows 7
Pasting current view 1
Hide row code help 1
How do I copy & paste only the unhidden data on a worksheet ? 1
How do I avoid copying data from hidden rows/columns? 2

Top