View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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