How can we help you?
Product:

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.In 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.In the context menu of the sheet, clear the Hide Zero Values check box.

Was this helpful?
Yes
No
Previous
Zoom a sheet
Next
Delete a sheet