missing cell rows (jumps from 2 directly to 9)

  • Thread starter Thread starter cpliu
  • Start date Start date
C

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,
 
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
 
Back
Top