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.
