K
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
an down I can see them both.
Thanks
/keith
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
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
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
K
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
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
D
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.
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.
G
Guest
will this change with next version?
David McRitchie said: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
D
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.
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.