Excel loses "Freeze Panes" setting

E

Eric

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.
 
D

Dave Peterson

Not that I know.
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I freeze the swimlane headers? 0
Unable to freeze panes 15
Freeze Panes loss 3
Excel freezing after sharing document by Email 0
Any way to get Freeze Panes to work with Split View? 2
Freeze column headers for ledger sheets 1
Use footer with freeze panes 0
Freeze panes grayed out 3

Top