Cannot unhide rows
 

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
--
stevemalee

Cannot unhide rows
 

Window/ Remove split.
--
David Biddulph

"stevemalee" wrote in message
...
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
--
stevemalee

Cannot unhide rows
 

Or WindowUnFreeze Panes


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Window/ Remove split.

Cannot unhide rows
 

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


"Gord Dibben" wrote:

Or WindowUnFreeze Panes


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Window/ Remove split.

Cannot unhide rows
 

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 ?
--
stevemalee


"Gord Dibben" wrote:

Or WindowUnFreeze Panes


Gord Dibben MS Excel MVP

On Wed, 2 Apr 2008 21:10:19 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

Window/ Remove split.

Cannot unhide rows
 

With the WindowFreeze 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 WindowsFreeze Panes.

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


Gord Dibben MS Excel MVP

On Sat, 12 Apr 2008 06:21:01 -0700, stevemalee wrote:

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 ?

Cannot unhide rows
 

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
--
stevemalee


"Gord Dibben" wrote:

With the WindowFreeze 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 WindowsFreeze Panes.

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


Gord Dibben MS Excel MVP

On Sat, 12 Apr 2008 06:21:01 -0700, stevemalee wrote:

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 ?

Cannot unhide rows
 

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


Gord

On Sun, 13 Apr 2008 09:24:00 -0700, stevemalee wrote:


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