Excel 2007 displays zero values in cells by default. You can customize and have Microsoft Excel display blank cell(s) when the value zero is in the cell(s). Perform the following steps to hide the display of zero values:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, scroll down to the Display options for this worksheet: section. Click to remove the checkmark besides Show a zero in cells that have zero value.
5. Click OK.
To show the zero value, repeat the above steps and click to place the checkmark besides Show a zero in cells that have zero value in step 4.
Note:
The option of showing or hiding the zero values applies only to the selected worksheet and not to the entire workbook.
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, scroll down to the Display options for this worksheet: section. Click to remove the checkmark besides Show a zero in cells that have zero value.
5. Click OK.
The option of showing or hiding the zero values applies only to the selected worksheet and not to the entire workbook.
0 comments:
Post a Comment