Cart 0

How to Hide Zero Values in Excel

Posted by Roger Hyttinen on

If you have formulas or functions in your spreadsheet that evaluate to zero, all those zeros can make your worksheet unsightly and messy, especially if you have a lot of zeros. Luckily, Excel has an option that allows you to hide zeros, giving your spreadsheet a more professional and polished look. This can also help you to find and evaluate cells that contain non-zero values.

To Hide Zeros in Excel

  1. Click the File tab on the Ribbon.
  2. Click Options.
  3. In the left pane, click the Advanced category.
  4. Scroll down until you see Display Options for this Worksheet.
  5. Click the checkbox next to Show a zero in cells that have zero value to clear it.
    uncheck the show a zero in cells that have zero value box
  6. Click OK.

Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks

Share this post

← Older Post Newer Post →