How do I suppress zeros on an excel spreadsheet? can I?

Question

Answer

Yes. All you need to do is to change your settings:

1.- Open Excel Options
    Excel 2007:
          Click the Office button at the upper-left corner;
          At the bottom, you will view the Excel Options button. 
          Click it into Excel Options Window.

    Excel 2010/2013/2016
          Click the File tab 
          Then you will view the Options button at left bar. 
          Click it into Excel Options window.

2.- From the left bar select ADVANCED

3.- Scroll down to DISPLAY OPTIONS FOR THIS WORKSHEET, and verify that the name of the worksheet is display, if not, select it from the drop down list.

4.- Under DISPLAY OPTIONS FOR THIS WORKSHEET there is a list of settings, uncheck SHOW A ZERO IN CELLS THAT HAVE ZERO VALUE

5.- Click the OK button on the botton-right corner

The change only applies to the worksheet. To applied the change to all or other worksheet, you need to repeat the steps for each worksheet.

To undo the change for a worksheet, just repeat the steps for that worksheet and in this case check SHOW A ZERO IN CELLS THAT HAVE ZERO VALUE

How do I suppress zeros on an excel spreadsheet? can I?

Answers (1)