Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 2nd 06, 10:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,670
Default 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   Report Post  
Old November 3rd 06, 12:21 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Calculator always requires an = before a math function, can be turned off setting? auto Excel Worksheet Functions 8 August 2nd 06 05:50 AM
how to set excel at the default setting for the enter key? sternface Excel Discussion (Misc queries) 2 July 14th 06 05:56 PM
Setting Excel chart series from vb6 Jim Charts and Charting in Excel 7 January 27th 06 09:41 AM
No shading or coloring of cells in excel. Is it windowXP setting? Marker123 Excel Discussion (Misc queries) 1 January 23rd 06 05:21 AM
Setting tab colours on Excel spreadsheets (for Excel 2000) S Excel Discussion (Misc queries) 2 June 15th 05 03:42 PM


All times are GMT +1. The time now is 09:39 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017