ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving freeze pane worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/243389-saving-freeze-pane-worksheet.html)

Lesaron

Saving freeze pane worksheet
 
Is there a way to save my excel worksheet with the freeze pane function still
active. So far I can activate the freeze pane where I need it, but even if I
save the worksheet, the freeze pane does not.

LesA

Jacob Skaria

Saving freeze pane worksheet
 
Excel save this setting within the workbook; so that next time you open you
should be able to view this setting.

(menu WindowFreeeze Panes)

If this post helps click Yes
---------------
Jacob Skaria


"Lesaron" wrote:

Is there a way to save my excel worksheet with the freeze pane function still
active. So far I can activate the freeze pane where I need it, but even if I
save the worksheet, the freeze pane does not.

LesA


Lesaron

Saving freeze pane worksheet
 
Jacob,
I have tried your suggestion, but Excel does not save it. I have to go to
Window, Freeze Panes everytime I open the same worksheet. I am using
MSOffice, 2003. Any other way to save the Freeze pane setting in an Excel
worksheet?

Les

"Jacob Skaria" wrote:

Excel save this setting within the workbook; so that next time you open you
should be able to view this setting.

(menu WindowFreeeze Panes)

If this post helps click Yes
---------------
Jacob Skaria


"Lesaron" wrote:

Is there a way to save my excel worksheet with the freeze pane function still
active. So far I can activate the freeze pane where I need it, but even if I
save the worksheet, the freeze pane does not.

LesA



All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com