WPS Hide Zero and Error Values on macOS FAQ

Last updated:July 20, 2026

When using Hide Zero and Error Values, the most common questions are about whether data changes, whether formulas are affected, and which errors can be hidden; this FAQ covers 4 common questions.

FAQ

Does Hide Zero and Error Values change the actual data in cells?

  1. No. This feature changes only how the cell content is displayed.
  2. After hiding, the original data and formulas still remain in the cells.
  3. If needed, clear the related option to check the original display again.

Will formulas that reference hidden zero-value cells be affected?

  1. No. Hiding zero values does not change the actual numeric value in the cell.
  2. Related formulas still calculate based on the original value.
  3. If you want to confirm, restore the display and compare the formula result again.

Why are some error values still visible?

  1. First confirm that you selected Hide #N/A.
  2. This option is designed for #N/A display items.
  3. If a cell shows another error type, it will not be hidden by this option.

Will the hidden display setting stay after I save the file?

  1. This feature works as a worksheet display setting.
  2. After saving the file, the display state is generally kept when you open it again.
  3. If you want the default display back, open the menu again and clear the related option.

Glossary

TermDefinition
Zero valueA cell result equal to 0. In this feature, the value can remain in the cell while its display is hidden.
#N/AA spreadsheet error result that often appears when a lookup or reference does not return a match.
Display stateThe visible appearance of a cell in the worksheet. Changing the display state does not mean changing the original data.