If a spreadsheet contains a lot of zero values, you might want to hide them to make you spreadsheet easier to read. The hidden zero values are not printed.

To hide zero values on the sheet, proceed as follows:

1.Right-click the sheet tab of the sheet containing the zero values that you want to hide.

2.On the context menu of the sheet, select the Hide zero values check box.

To display previously hidden zero values on the sheet, proceed as follows:

1.Right-click the sheet tab of the sheet containing the zero values that you want to display.

2.On the context menu of the sheet, select the Display zero values check box.

To hide or unhide the zero values, check or uncheck the box in the Table > Sheet > Hide zero values command menu item.

Was the material useful?
Yes
No
Users found this material useful: 0 из 0