WPS Hide Zero and Error Values on Windows FAQ

Last updated:July 20, 2026

When using Hide Zero and Error Values, the most common questions are about display behavior, formula impact, and restoring the original view; this FAQ includes 4 common questions and 4 glossary terms.

FAQ

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

  1. No. This feature only changes how the worksheet is displayed.
  2. The original values, formulas, and references remain in the cells.
  3. If needed, select a cell and check the formula bar to confirm the original content.

Will formulas that reference hidden zero values still work?

  1. Yes. Hiding zero values does not turn the cell into an empty value.
  2. The actual value is still 0, so related formulas continue to calculate as before.
  3. If you need a different calculation result, change the formula logic instead of only changing the display.

Why are some error values still visible?

  1. This feature is designed for the display of #N/A results.
  2. Other error types such as #REF!, #VALUE!, or #DIV/0! are outside this switch.
  3. For other errors, review the formula, reference range, or source data.

Why do the values appear again after I turn the option off?

  1. This is expected because the feature works as a display toggle.
  2. When you clear Hide Zero Values or Hide #N/A, the previously hidden results appear again.
  3. If you want to keep the current display, confirm the setting before saving the file.

Glossary

TermDefinition
Zero valueA cell result equal to 0. When hidden, it is only removed from view, not deleted from the worksheet.
#N/AA spreadsheet error value that usually means no matching result was found or a referenced result is unavailable.
Worksheet-level displayA setting that changes how the current worksheet looks without rewriting the underlying data.
Formula barThe input area used to view or edit the original content of the selected cell.