Ask Experts Questions for FREE Help !
Ask
    daleand's Avatar
    daleand Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 21, 2008, 12:27 PM
    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.
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
    		  
    #2

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Intertherm Electric Furnace Blower works in "on" not in "auto" [ 6 Answers ]

I have an Intertherm Electric Furnace E2EB-015AH. I came home from work last night, turned the heat on and it didn't work as advertised. I could hear the relays clicking occasionally so I investigated a little and found the elements are heating up and cycling, the relay inside the thermostat cycles...

Music from the documentary "napoli corner" or "maradona in naples" [ 4 Answers ]

"what's the big deal?" about using the words "pimped out" in reference to Chelsea? [ 11 Answers ]

Some people don’t seem to think it is a big deal. Clinton Calls Shuster Comment Part of 'Troubling Pattern' | The Trail | washingtonpost.com

Honda accord 2000 6 cyl " the light "check" is on" [ 1 Answers ]

My honda accord 2000 6 cyl. With 101000k miles is was with the light "check" on. I took To a non-honda mechanic and he erased it. The computer said that the code is PO700, and the mechanic said that it needs to have the "transmission rebuilt", and the price ranges from $ 1500.00 - 1600.00. My...

Windows & Firefox: Right Click "Open With" Option [ 5 Answers ]

Been mostly using FF this year but some sites don't play well - and some impossible. I've got shortcuts to these sites on my desktop. I'd really love to "designate" them as IE shortcuts so that they'll open with IE if I click on them. ... but if this is not possible, I'd like to at least...

View more questions Search