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?



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.


OzGrid Business Applications