excel rows disappear
 

row numbers turn blue, cannot unhide, but can drag

excel rows disappear
 

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" wrote:

row numbers turn blue, cannot unhide, but can drag

excel rows disappear
 

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

"Mike H" wrote:

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" wrote:

row numbers turn blue, cannot unhide, but can drag

excel rows disappear
 

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

"kerry" wrote:

row numbers turn blue, cannot unhide, but can drag