Video Tutorial: How to Hide Zero Values in Excel 2010

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

What do you think?

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s