![]() ![]() The reason that the frozen panes are not saved is because FreezePanes (along with Zoom, Split, and a few other settings) are properties of windows, not of worksheets or workbooks. There is no setting in Excel that will handle what Steven needs to happen. ![]() Steven wonders if there is a way to get the new window to retain the frozen panes settings? If he closes the original window first, when he saves the workbook it saves all the unfrozen worksheets. As he has frozen panes on many worksheets in this workbook, he has to be very careful about which window he closes first. ![]() However, if Steven opens a new window for the workbook (View | Window | New Window), the new window does not have frozen panes. He can even save and close the workbook, and the panes are still frozen when he reopens the workbook. He has frozen the first row and column by making cell B2 active and then freezing panes. Steven has a worksheet with many rows and columns of data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |