Row Header Mystery

[Karen]

I have a spreadsheet that starts with row heading one and then the next row
is 1865. I'm confused! I tried to unhide the rows, but they are not hidden.
What else could it be?
I'm using Excel 2003

Any help would be greatly appreciated
Karen

 

[Jacob Skaria]

Hit Ctrl+A to select all cells and then try unhiding the row from menu
Format>Row>Unhide

 

[David Biddulph]

Could be zero height. Select row 1, shift select row 1865, double check that
you can't unhide the rows, the Format/ Rows/ Height, either Autofit or some
suitable number.

 

[Dave Peterson]

I'd try:
Window|Unfreeze panes
Then scroll up (you may have to try unhiding the rows again).

Or maybe....

Data|filter|show all

 

[Gord Dibben]

You have Freeze Panes enabled and have slid rows 2 to 1864 under row 1

Just scroll up to see rows.


Gord Dibben MS Excel MVP

 

[Karen]

Thanks - I just gave that a try and it's still the same.
Thanks again, Karen

 

[Karen]

Thanks - I just gave that a try and it's still the same.
Thanks again, Karen

 

[Karen]

Thank you for your help - I'm sorry, I don't understand what you are saying.
Karen

 

[Karen]

Thanks - That's exactly what I did prior to posting this and nothing changed.
Thanks, Karen

 

[Gord Dibben]

Send the workbook to me personally via email.

gorddibbATshawDOTca

Change the AT and DOT


Gord

 

[Gord Dibben]

If anyone is interested...........been a while<g>

Karen sent me the workbook.

Autofilter was enabled on column S only and sheet was filtered.

Remove filter and show all retrieved the hidden rows.


Gord