In this video tutorial, I show you two ways to hide zero values in Excel 2010. In my example, I have a worksheet with formulas to add two amounts that I will be adding to throughout the year. Since I don’t want the zeros to appear in my worksheet, I try two different methods to hide them.

The first is by using Advanced Excel Options (File – Options – Advanced – Display Options for this Worksheet) and un-checking the “Show a zero in cells that have zero value” box.

The second method is by selecting the part or all of the worksheet to apply the formatting to and using Conditional Formatting (Home – Conditional Formatting – Highlight Cells Rules – Equal To) and formatting cells that are equal to 0 with custom formatting. In custom formatting, I change the font color to white. This changes all zero values to white so they are hidden from view and from printing.

This video was created using Cam Studio (http://camstudio.org).

Advertisements