Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel loses "Freeze Panes" setting
I'm working with a big workbook with multiple sheets. I sometimes need to
view sheets side by side, so I use the normal Window / New Window and Window / Arrange functions. However, when I do this, Excel seems to lose the Freeze Panes formatting within the sheets, and I have to restore it manually. so the header rows remain visible as I'm scrolling. (Alternatively, I can manage without the Freeze Panes when I'm viewing multiple windows, but I still have to restore Freeze Panes when I get out of the "view multiple windows" mode.) Is there any way to view multiple sheets without losing the Freeze Panes settings? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel loses "Freeze Panes" setting
Not that I know.
Eric wrote: I'm working with a big workbook with multiple sheets. I sometimes need to view sheets side by side, so I use the normal Window / New Window and Window / Arrange functions. However, when I do this, Excel seems to lose the Freeze Panes formatting within the sheets, and I have to restore it manually. so the header rows remain visible as I'm scrolling. (Alternatively, I can manage without the Freeze Panes when I'm viewing multiple windows, but I still have to restore Freeze Panes when I get out of the "view multiple windows" mode.) Is there any way to view multiple sheets without losing the Freeze Panes settings? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Calculator always requires an = before a math function, can be turned off setting? | Excel Worksheet Functions | |||
how to set excel at the default setting for the enter key? | Excel Discussion (Misc queries) | |||
Setting Excel chart series from vb6 | Charts and Charting in Excel | |||
No shading or coloring of cells in excel. Is it windowXP setting? | Excel Discussion (Misc queries) | |||
Setting tab colours on Excel spreadsheets (for Excel 2000) | Excel Discussion (Misc queries) |