Forum Discussion
Options won't open in files on Excel
Hi, I'm trying to hide zero values in excel spread sheet.
I've selected files>Options but when I do I get taken back to the same worksheet. Nothing is opening and I can't continue to advanced to hide the zero values.
Any advice please most welcome
Many Thanks in advance
- I had the same problem several people in this thread described. I managed to solve it the following way:
1) Close all open Excel files.
2) Go to `Start` and type `Excel` in the search box.
3) Click on the Excel icon to open the application.
4) When Excel opens and prompts you to select a file, don't open any file (nor create a new one).
5) Go to the bottom left and select `Options`.
6) The `Excel Options` windows will now pop up and you can modify the Excel options.
I hope this helps any other people facing the same issue in the future.
25 Replies
- I had the same problem several people in this thread described. I managed to solve it the following way:
1) Close all open Excel files.
2) Go to `Start` and type `Excel` in the search box.
3) Click on the Excel icon to open the application.
4) When Excel opens and prompts you to select a file, don't open any file (nor create a new one).
5) Go to the bottom left and select `Options`.
6) The `Excel Options` windows will now pop up and you can modify the Excel options.
I hope this helps any other people facing the same issue in the future.leobeeson
Thanks Leo
That was a good quick (and logical) fix...
It must be a software update glitch; I've modified spreadsheet options literally thousands of times and that's the first time that's happened...
Thanks again...
You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values.
There are several ways to display or hide zero values.
examble of One way, find more ways in the Link.
Hide or display all zero values on a worksheet
Click File > Options > Advanced.
Under Display options for this worksheet, select a worksheet, and then do one of the following:
To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.
To display zero (0) values as blank cells, uncheck the Show a zero in cells that have zero value check box.
examble of second way:
Return a blank cell when the value is zero, you can use this formula.
=IF(A2-A3=0,””,A2-A3)
More ways you find in the Link: Display or hide zero values
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
I have the same problem, which your answer does not address.
the primary problem is that >file>options will not open, instead excel reverts to your document instead of the options window.
I just recently downloaded microsoft 365 and when I attempted to work on excel macros I found that I could not access options. I on get a sheet with the following:
OptionsRegional Format SettingsChange your regional format settings for Excel for the web
