change excel row height without showing hidden rows

L

LL

I have a large Excel worksheet with numerous hidden rows. When I try to
change the height of all rows in the spreadsheet the hidden ones reappear.
Can this be avoided? Is there a way to delete these rows without having to
highlight each one?
 
B

Bernie Deitrick

LL,

Select all your rows, use Edit | Go To Special Visible Cells only, then
change the height of your rows.

HTH,
Bernie
MS Excel MVP
 
Top