Display or hide zero values – Excel – Microsoft Office Online

Display or hide zero values – Excel – Microsoft Office Online
You may have a personal preference to display zero values in a cell, or you may be using a spreadsheet that adheres to a set of format standards that requires you to hide zero values. There are several ways to display or hide zero values.

2 thoughts on “Display or hide zero values – Excel – Microsoft Office Online”

  1. This link is for Office 2007. For earlier versions, go to Tools, Options and from the View tab look for the ‘zero values’ check box in the bottom section (window options).
    :o)

Leave a Reply

Your email address will not be published. Required fields are marked *