Keep freeze panes setting when opening a second window.
Keep freeze panes setting when opening a second window. I frequently open a new window (second view of the same workbook) so I can make changes on one tab of the workbook and instantaneously view the results on a second tab of the workbook without having to select back and forth between two tabs. The problem is once the second view is opened it no longer adheres to the freeze pane settings of the workbook. I find myself re-freezing the panes multiple times a day.
It is hard to believe that Excel's programmers can build such an incredible, evolving, feature-rich program but cannot devote some time to correct this "freeze panes plus" flaw.
Couldn't agree more. It has been a real productivity waster for years, having to reset the panes every time.
Bill Botts commented
Upgrade? Why would the intended design to be to lose curated settings (particularly in such a productivity mode)? MICROSOFT PLEASE FIX THIS OR AT LEAST EXPLAIN WHY THIS IS AN INTENDED DESIGN? Its driving me maddddddd
Hi, for ones looking for a solution to this in the short term try these macros. I haven't tested them myself yet, but I trust Excel Campus' content.
Did anybody ever figure out a solution to this? Very frustrating
Jon Acampora commented
This fix should include gridlines, headings, and all Window level settings/properties that are lost when a new window is opened. Thank you!
Erica Price commented
I would also find this suggestion very helpful if implemented.
Brian Arriaga commented
I would like to see this change as well. Keep the freeze panes settings when opening a new window of the same workbook.
Yes please, also gridlines start showing, whereas in original window they are turned off
Yes please. This would be a fabulous upgrade. Always re-freezing in second window. So annoying.
Richard Noakes commented
YES! Please keep the freeze panes settings for each tab regardless of how many windows are open.
I have to continually re-freeze panes and it's becoming a real nuisance, especially when building formulas.