How to Hide Zero Amount Values in Microsoft Excel

I am putting together an invoice in Excel. How can I hide zeros from showing in the “total” column of empty lines?

You can display or hide zero amounts in Excel by changing a few options. There are a few different ways to hide zero amount values:

• Hide zero amount values in the entire worksheet.
• Hide zero amount values in selected cells.
• Hide zero amount values returned by a formula.
• Display zeros as blanks or dashes.

In short, you can hide zero amount values from displaying throughout the entire worksheet by clicking Tools → Options → View, and un-checking the “zero values” check box. If you would like to only hide selected zero amount values, or modify a formula to hide them, consult “Display or hide zero values - Excel” in the Microsoft Office Online help site. The article explains how to accomplish each of these tasks.