PDA

View Full Version : Looking for a way to set the "zero values" option to unchecked for all sheets.


daleand
Apr 21, 2008, 12:27 PM
Folks. I am looking to set the "zero values" to unchecked (this setting is found in tools - options- view tab). I would like to set this value to unchecked for all spreadsheets that will be created from now on. If I remove the check and save the value it only affects the workbook I currently have open. Thanks.

mdosh01
Apr 22, 2008, 05:46 AM
The only way I can think of doing this is with a template. Search on "Create a template" in Excel help. Save the template with the desired setting and follow the instructions. This template will then be used whenever you open Excel or click "new".

Hope this works for you.