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.
I have used the macros from this site and works great.
Chuck Klaniecki commented
I find it close to absurd (1) that Excel EVER failed to retain these settings, and (2) that this problem has persisted so long.
Microsofties: Please address ASAP.
FWIW, I'm wholly aware that it's considered unprofessional to offer to kiss the feet of a programmer for implementing a much-needed feature improvement, and thus I will refrain from doing so. (However, I would be SORELY tempted, and I figured someone might wish to know...)
David Nightingale commented
here here!!! Such an infuriating non-feature!!!! Come on MS - this must surely be a simple quick fix
Exactly what Katie says. This is a waste of time. 2nd windows of the same workbook are an increase of productivity but not if you have to constantly go back and reapply settings. Also, having to program macros to find all the settings seems like something Excel should be doing when it opens a new window of the same workbook. Please fix this.
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.