How To Suppress Cells That Calculate Zero


Key to Instructions
To help readers follow the instructions in this article, we use two different typefaces.
Boldface type identifies the names of icons, agendas, URLs and application commands.
Sans serif type indicates instructions and commands that users should type and file names.
 
Q. When I create a spreadsheet in Excel, I usually want to suppress any cell that calculates to 0 (zero). Is there a way to do this?

A. Yes, and it takes just a few steps. Go to Tools , Options , and click on the View tab. Near the bottom of the Options screen (see right) uncheck the Zero values box.

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.