Excel 2007
Home Up Outloook 2007 Word 2007 PPT 2007 Tech Notes Access 2007 Internet Explorer Windows Vista About Us Office 2003


Display or Hide Zeroes

By default, Excel displays the data as it is typed in. This includes zero values.

To control the display of typed zero values;

Click the Office Button
Click Excel Options at the bottom of the screen
Select Advanced
Scroll down to Display options for this worksheet section
Go to Show a zero in cells that have a zero value
    Checked box displays zero value on screen and printout (recommended option)
    Unchecked box displays no zero value
OK to save the changes

 


Updated:  November 18, 2009
 
 Sr. Arlene Callahan
 Training Manager
 Rivier College
 Nashua, NH 03060
 Phone: 603.897.8660
 E-mail: acallahan@rivier.edu