excel rows disappear

[kerry]

row numbers turn blue, cannot unhide, but can drag

 

[Mike H]

Kerry,

Blue row numbers suggest they are hidden because of an autofilter and they
can't be unhidden by dragging, the only way is to remove the filter.


Mike

 

[kerry]

wow, what a ditz, i should have thought about that, thank you very much

 

[bibilulu]

I had a similar problem, if you are using filters, try selecting the entire
worksheet and turning the filters off and then resetting them.