Cannot unhide rows

[stevemalee]

I don't know if this is the correct group, but I have searched other threads
and tried to fix my problem which is similar and nothing works.

I have Excel 2003, XP Pro.

I can see rows 1-16. In order to see the next rows I can use the down arrow
button to see 17, etc. However, then the page goes back to hiding rows below
row 16.

I do not remember ever hiding any rows. I would not have known what to do.

The work sheet has columns A to M. There is a cross in the middle of the
sheet. The vertical line is between column F and G. The horizontal line is
between 16 and 23. The rows between 16 and 23 are hidden unless I use the
down arrow at row 16.

I do not want these rows to be hidden. It messes up my entire sheet since I
cannot find easily what is where.

Thanks

 

[David Biddulph]

Window/ Remove split.

 

[Gord Dibben]

Or Window>UnFreeze Panes


Gord Dibben MS Excel MVP

 

[stevemalee]

Thanks so much. The unfreexe panes worked. I didn't try that prior because
I thought it would remove the function of saving the titles of the columns,
but I froze again and the titles stayed.

 

[stevemalee]

I replied that all was OK too soon.

The next time I opened the sheet the rows were hidden again.

And, after I "unfroze" I lost the top titles when I scrolled down.

So, is there another answer to this problem ?

 

[Gord Dibben]

With the Window>Freeze Panes disabled can you see all the rows?

If so, maybe you are "freezing" at the wrong location.

The freezing rule is..............all rows above and left of the selected cell
will be frozen when you go to Windows>Freeze Panes.

i.e to freeze row 1 and column A, select B2 the freeze.


Gord Dibben MS Excel MVP

 

[stevemalee]

Yes I was using the wrong place to freeze.

I thought it was the small corner without any number or alphabet at the very
top of the sheet directly above the numbers of the rows and farthest to the
left of the column letters.

What you recommended seems to work. Thanks

 

[Gord Dibben]

The small corner button you refer to is the "select all cells" button.


Gord