Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]() Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on one worksheet' Is it possible in Excel 2003 to freeze the panes of certain groups of cells within one worksheet? For example: If I want to have four sections (for instance: cells A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I want each of these to contain a split 1/2 way down, where the panes are frozen. Is this possible? So far I have not found a way. Please let me know. I truly appreciate any advice. Best regards, Joanna (Frustrated Word (& Excel) User) -- Frustrated Word User |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
You get one freeze panes (or split) per window.
But maybe you could use window|new window and arrange them the way you like. When you're done, you can select the window you don't want and hit ctrl-w to close it. Frustrated Word User wrote: Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on one worksheet' Is it possible in Excel 2003 to freeze the panes of certain groups of cells within one worksheet? For example: If I want to have four sections (for instance: cells A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I want each of these to contain a split 1/2 way down, where the panes are frozen. Is this possible? So far I have not found a way. Please let me know. I truly appreciate any advice. Best regards, Joanna (Frustrated Word (& Excel) User) -- Frustrated Word User -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]() Thanks Dave, I just ended up creating buttons and writing show and hide macros in the same worksheet. I appreciate your advice. TGIF!! Dave Peterson;3540971 Wrote: You get one freeze panes (or split) per window. But maybe you could use window|new window and arrange them the way you like. When you're done, you can select the window you don't want and hit ctrl-w to close it. Frustrated Word User wrote:- Greetings All! [Title is supposed to read 'Multiple "Freeze Panes" on one worksheet' Is it possible in Excel 2003 to freeze the panes of certain groups of cells within one worksheet? For example: If I want to have four sections (for instance: cells A4-F4 by A4-A24(F24)) Four square sets of cells on one worksheet. I want each of these to contain a split 1/2 way down, where the panes are frozen. Is this possible? So far I have not found a way. Please let me know. I truly appreciate any advice. Best regards, Joanna (Frustrated Word (& Excel) User) -- Frustrated Word User- -- Dave Peterson -- Frustrated Word User |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing "Freeze Panes" | Excel Worksheet Functions | |||
Print "freeze panes" on succeeding pages? | Excel Discussion (Misc queries) | |||
I want to lock row 1 in Excel. Why is "Freeze Panes" grayed out? | Excel Discussion (Misc queries) | |||
Excel loses "Freeze Panes" setting | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) |