Freezing Top and Bottom Rows

[Keith Camacho]

Can I Freeze both Top and bottom pane on my worksheet, so when I scrool up
an down I can see them both.
Thanks
/keith

 

[Gord Dibben]

Keith

No.

Just the top row(s) can be frozen.

Sort of work-around.....Window>New Window>Arrange>Horizontal.

Have one skinny window at bottom and freeze top row in top window.

Turn off row and column headers, scroll bars and sheet tabs on skinny window.


Gord Dibben Excel MVP

 

[Kenny Dee]

Yes you can freeze a top and bottom. Be sure to select the cell below the
cell you want to freeze. So select you top now. Now while holding down your
Ctrl button select you bottom cell. Again be sure you select the cell below
for the cell you want to freeze. Now in the menu under Window select Freeze
Pane. This will freeze only the cells above the cell you've selected.
----- Original Message -----
From: "Keith Camacho" <[email protected]>
Newsgroups: microsoft.public.excel
Sent: Friday, April 08, 2005 7:47 PM
Subject: Freezing Top and Bottom Rows

 

[David McRitchie]

Hi Kenny,
You can ONLY freeze the TOP of a worksheet (and/or the LEFT side of
a worksheet) . See the other reply in this thread for help with
matching another view of the sheet at the bottom but it is not frozen
and you would have to scroll the lower view independently to match
the columns as shown in the upper view.

 

[Guest]

will this change with next version?

Hi Kenny,
You can ONLY freeze the TOP of a worksheet (and/or the LEFT side of
a worksheet) . See the other reply in this thread for help with
matching another view of the sheet at the bottom but it is not frozen
and you would have to scroll the lower view independently to match
the columns as shown in the upper view.

the

 

[David McRitchie]

Play on the words freeze and frozen, possibly before the next ice age.

As long as Excel is separate from Word, I doubt
that you will see that soon. Excel is not for publishing.
You can't even print labels directly from Excel to different
printers without losing sanity.