Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 10 (office XP) sp3
Is it possible to freeze the top few lines and the bottom few lines of a sheet so that when you scroll down only the middle section moves. I have headings at the top and totals at the bottom and I would like them visible at all times if possible. Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I don't know about double freezing, but you cd put the totals at the top just under the headings, and enlarge the frozen pane to accomodate. -- Nyq ------------------------------------------------------------------------ Nyq's Profile: http://www.excelforum.com/member.php...o&userid=35380 View this thread: http://www.excelforum.com/showthread...hreadid=551675 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Nyq" wrote in message
... I don't know about double freezing, but you cd put the totals at the top just under the headings, and enlarge the frozen pane to accomodate. .... or fire up a second (new) window, arrange horizontally, and have the lower window with just the totals, and freeze-pane the upper window containing the headings and the data in the middle section. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FREEZE PANE | Excel Discussion (Misc queries) | |||
freeze pane | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
Freeze pane | Excel Worksheet Functions | |||
Freeze pane | Excel Worksheet Functions |