Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
Hi!
I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
hi
2003 on the menu bar.... widowfreeze panes 2007.... viewwindow groupfreeze panes you can freeze row and/or columns place the curser at A2 then click freeze panes to freeze the top row. place the curser at b2 to freeze top row and column A. freeze pane is boolene. click to freeze. click again to unfreeze. when freezing panes, everything from the curser down and to the left will freeze. Regards FSt1 "Jason" wrote: Hi! I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
Thanks a bunch! Yeeha.
"FSt1" wrote: hi 2003 on the menu bar.... widowfreeze panes 2007.... viewwindow groupfreeze panes you can freeze row and/or columns place the curser at A2 then click freeze panes to freeze the top row. place the curser at b2 to freeze top row and column A. freeze pane is boolene. click to freeze. click again to unfreeze. when freezing panes, everything from the curser down and to the left will freeze. Regards FSt1 "Jason" wrote: Hi! I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
correction...
when freezing panes, everything from the curser down and to the left will freeze. should be.. when freezing panes, everything from the curser up and to the right will freeze. sorry FSt1 "FSt1" wrote: hi 2003 on the menu bar.... widowfreeze panes 2007.... viewwindow groupfreeze panes you can freeze row and/or columns place the curser at A2 then click freeze panes to freeze the top row. place the curser at b2 to freeze top row and column A. freeze pane is boolene. click to freeze. click again to unfreeze. when freezing panes, everything from the curser down and to the left will freeze. Regards FSt1 "Jason" wrote: Hi! I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
Up and to the left? [But actually above and to the left; the row and
column including the cursor are not frozen.] -- David Biddulph FSt1 wrote: correction... when freezing panes, everything from the curser down and to the left will freeze. should be.. when freezing panes, everything from the curser up and to the right will freeze. sorry FSt1 "FSt1" wrote: hi 2003 on the menu bar.... widowfreeze panes 2007.... viewwindow groupfreeze panes you can freeze row and/or columns place the curser at A2 then click freeze panes to freeze the top row. place the curser at b2 to freeze top row and column A. freeze pane is boolene. click to freeze. click again to unfreeze. when freezing panes, everything from the curser down and to the left will freeze. Regards FSt1 "Jason" wrote: Hi! I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Scrolling with a Page
yes. by the correction you see i had a problem wording this and did get
"turned around". sorry but the OP seems excited so maybe I steered him it the right direction which was i aim. maybe he can sort out the rest via trial and error. Regards FSt1 "David Biddulph" wrote: Up and to the left? [But actually above and to the left; the row and column including the cursor are not frozen.] -- David Biddulph FSt1 wrote: correction... when freezing panes, everything from the curser down and to the left will freeze. should be.. when freezing panes, everything from the curser up and to the right will freeze. sorry FSt1 "FSt1" wrote: hi 2003 on the menu bar.... widowfreeze panes 2007.... viewwindow groupfreeze panes you can freeze row and/or columns place the curser at A2 then click freeze panes to freeze the top row. place the curser at b2 to freeze top row and column A. freeze pane is boolene. click to freeze. click again to unfreeze. when freezing panes, everything from the curser down and to the left will freeze. Regards FSt1 "Jason" wrote: Hi! I recently used an Excel sheet where the first row was not only printed at the top of each page (I can do that.), but scrolled with the page as I moved downward. I'll bet it's simple but can't figure out how to do it. Can someone please help? Thanks, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop page totals creeping up page when scrolling | Excel Discussion (Misc queries) | |||
Stationary cursor, scrolling page | Excel Worksheet Functions | |||
Scrolling in Page Break Preview | Excel Worksheet Functions | |||
Scrolling excel page using down and up arrow | Excel Discussion (Misc queries) | |||
How do I go from one page to another in excel without scrolling? | Excel Worksheet Functions |