change excel row height without showing hidden rows

G

Guest

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
 

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

unhide row does not unhide the hidden rows 4
Auto fit row height 2
hiding/unhiding rows 1
Excel - viewing hidden rows 2
Is there a function to show if cell/row(X:Y) is hidden? or width? 3
How do I stop Excel from automatically resizing my row height? 0
Excel autofit row height not working 0
need to input alternate blank rows in spreadsheet 5

Top