Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Doing nothing wrong Rick.
You cannot use both together. OP could conceivably use two windows. One skinny window with totals row showing at bottom of first window. But I would move my totals row up to the top and freeze that along with the Title rows per your first post. Gord On Mon, 9 Jun 2008 17:58:19 -0400, "Rick Rothstein \(MVP - VB\)" wrote: Am I doing something wrong? My XL2003 will only freeze or split, but not both at the same time (the small gray box disappears when I elect to freeze the rows). Rick "Reitanos" wrote in message ... The title of your post has the answer to your question: 1) Use Window/Freeze Panes command after selecting cell A3 to get the 3 rows at the top to remain when scrolling 2) Use the Split feature (accessed by the small gray box above the vertical scroll bar or Windows/Split) to split your total row into a separate pane that will scroll independently On Jun 9, 5:08 pm, Thor wrote: I'm working on a Excel 2003 sheet. I want the three row column titles to stay at the top as you scroll down the page AND I want the total row, a couple of hundred rows below to always show when scrolling, This means that the title rows and total row is always seen when scrolling. -- Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
freeze frames button inactive | Excel Worksheet Functions | |||
Split / Freeze Pane's | Excel Worksheet Functions | |||
Split vs. Freeze | New Users to Excel | |||
split and freeze | Excel Discussion (Misc queries) |