Excel- Saving only unhidden rows

A

arich

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.
 
T

tina

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
 
Top