Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Looking for a way to set the "zero values" option to unchecked for all sheets. (https://www.askmehelpdesk.com/showthread.php?t=208157)

  • Apr 21, 2008, 12:27 PM
    daleand
    Looking for a way to set the "zero values" option to unchecked for all sheets.
    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.
  • Apr 22, 2008, 05:46 AM
    mdosh01
    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.

  • All times are GMT -7. The time now is 12:18 AM.