missing cell rows (jumps from 2 directly to 9)

[cpliu]

I wonder why a excel file I received have some rows invisible. It
jumps directly from 2 to 9 and no 3 to 8? It's not hidden as hide is
grayed.

Thanks,

 

[Dave Peterson]

It could mean that the worksheet is filtered. Do you see arrows on any of the
"header" cells (row 1???)

Look at the row numbers. Are they grey or blue?

If they're blue, it's autofilter.
Try this (xl2003 menus):
Data|Filter|show all

I'm not sure what "hide is grayed" means, but if it's not autofilter, then try
this next.

F5 (same as Edit|goto)
type:
1:65536
and hit enter

Then on the toolbar:
Format|row|unhide

 

[cpliu]

dave,
Row | Unhide shows everything.
Thanks for your help.