MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 97 display settings


Posted by brian on January 05, 2001 8:28 PM

Mr. Excel-
In Excel 97, when I set the zoom and display options (ie.-50%, gridlines off, freeze panes)and then save the workbook, I find that my changes are not saved. The settings revert. How can I avoid this?

Thanks.

-Brian


Posted by Dave on January 05, 2001 10:48 PM


Hi Brian

Excel should retain these settings for a particular workbook once saved. However this will not be the case for a new workbook. To do this you will need to save as a template.

Dave


OzGrid Business Applications