You spend time setting up your worksheets exactly the way you want them – the headings are frozen at the top of the screen, gridlines are turned off, and a few other customizations are made. Beautiful!
冻结窗格在Excel中消失 (Freeze Panes Disappear in Excel)
When you open the file the next day, you appreciate all the effort that you put into setting things up. It's much easier to work with the file this way.
A couple of days later, you cheerfully open your file again, and…what happened? All those special settings are gone. Nobody else has touched the file (or so they say), so how could all those settings have disappeared?
几天后，您又高兴地再次打开文件，……发生了什么事？ 所有这些特殊设置均已消失。 没有人触摸过该文件(或者说他们说过)，那么所有这些设置怎么会消失呢？
This occurred in John's files occasionally, and he asked if I could figure out what was going wrong. Thanks John, for inspiring this blog post and video.
责怪窗户 (Blame the Windows)
If this has happened to your files, you can probably stop grilling your co-workers, to find out who messed with your workbook. The most likely culprit is you – if you opened a second window in the workbook.
For example, you might open a second window to see the cell formulas in one window, and the formula results in another window. Or you can look at two different sheet in the same workbook, side by side.
What you might not notice though, is that the second window doesn't retain the freeze panes, gridlines and other settings that you so carefully applied. It uses the default window settings.
For example, in the screen shot below, the original settings are in the window at the right – FreezePanes.xlsx:1. The new window is at the left, and its window settings are different.
- Freeze Panes line missing in new window 在新窗口中缺少“冻结窗格”行
- Gridlines visible in new window 网格线在新窗口中可见
Then, when you're finished with the extra window, you close one of them. And, if you close the original window, instead of the second window, you'll lose your window settings, and be left with the defaults. What a pain! Or should that be "what a pane!"
然后，完成额外的窗口后，关闭其中一个窗口。 而且，如果关闭原始窗口而不是第二个窗口，则会丢失窗口设置，并保留默认设置。 真痛苦！ 或者应该是“什么窗格”！
小心关闭Windows (Close Windows Carefully)
If you have opened one or more new windows in a workbook, be careful when you're closing them. You'll see a window number, along with the file name, in each window's title bar.
Leave the original window (FreezePanes.xlsx:1) open, and close the other windows (FreezePanes.xlsx:2). That should prevent the accidental loss of your freeze panes, and other settings.
观看窗口设置视频 (Watch the Window Settings Video)
To see the steps for setting and preserving your Excel window settings, watch this short video tutorial.