Microsoft Office‎ > ‎Excel‎ > ‎

Using Zero


Display or hide all zero values on a worksheet

  • Click the File tab, click Options, click Advanced, and scroll down to Display Advanced Options for this worksheet then click OK

Use a number format to hide zero values in selected cells

  • Select the cell that contains the zero values you want to hide
  • Right click and go to format cells
  • Click custom

  • Choose the type of zero you wish to be displayed. 

Still have questions?

Call the Elmira College Help Desk at 607-735-1915 and speak with one of our talented IT consultants!