Rows reverts to zero height

C

Ciecie

I have a sheet that has about 500 rows. At times, some of the rows are at a zero height without me changing row heights or hiding rows. Ex.: I can see rows ...100, 101, 102,then 176, 177, 178... How do I prevents rows from changing to zero height, and how do I change the row heights back more than one at a time? Currently, the only way I know how to show the rows is by pulling down each row, one row at a time. The "Unhide Rows" command does not work.

Thanks,
Ciecie
 
G

Gord Dibben

Ciecie

Sounds like you may have some worksheet code that is setting rows to 0 on some
condition.

Right-click on the sheet tab and select "View Code". Anything in there(other
than "Option Explicit")?

To reset more than one row at a time, left-click on one row header then drag
down to select many. Format>Row>Height. Enter a number....12.75 is usually
the default.

To reset all rows on the sheet, hit CRTL + A then Format>Row>Height.

Gord Dibben Excel MVP
 
H

Hank Scorpio

I have a sheet that has about 500 rows.
At times, some of the rows are at a zero height without me changing row heights or hiding rows.
Ex.: I can see rows ...100, 101, 102,then 176, 177, 178... How do I prevents rows from changing
to zero height, and how do I change the row heights back more than one at a time?

In addition to Gord's suggestion, check to see what colour the row
headings are. If they're blue, then the chances are that you have an
Autofilter in place. Go to Data -> Filter -> See whether AutoFilter is
checked. If it is, turn it off.
 
D

Dave Peterson

And just to add to Hank's reply, it could be Data|filter|Advanced filter that's
in effect.

With either of them, the row header numbers will be different (blue on my
standard windows setup).

And you can unhide either version with
data|filter|showall

(With autofilter, you should see some dropdown arrows on the top row of the
autofilter range.)
 

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

Top