How to Hide Zero and Error Values in WPS on Windows

Last updated:July 20, 2026

Use Hide Zero and Error Values with 3 how-to topics, including 3 free topics and 0 membership-related topics, and jump to any task from the index below.

How-to Index

No.TopicMembership Requirement
11. Open the Hide Zero and Error Values menuFree
22. Hide zero valuesFree
33. Hide #N/A values and restore the displayFree

How-to Guide

1. Open the Hide Zero and Error Values menu

Entry path: View tab → Hide Zero and Error Values

  1. Open the worksheet that you want to clean up.
  2. Click the View tab on the top menu bar.
  3. Find Hide Zero and Error Values on the toolbar.
  4. Click it to open the drop-down menu.

Success Criteria

  • Interface result: You can see a menu with the available hide options.
  • Next action available: You can continue with Hide Zero Values or Hide #N/A.

Tips While Using

  • Common mistake: If you are not in a worksheet, the entry may not appear.

2. Hide zero values

Entry path: View tab → Hide Zero and Error Values → Hide Zero Values

  1. Open the Hide Zero and Error Values menu.
  2. Select Hide Zero Values.
  3. Check the worksheet to confirm that cells with a value of 0 now appear blank.
  4. To show them again, clear Hide Zero Values.

Success Criteria

  • Interface result: Cells with a value of 0 appear blank in the worksheet.
  • Next action available: You can still view the original value in the formula bar and continue working with formulas.
  • No side effect: The actual cell data is not changed.

Tips While Using

  • Common mistake: Treating a blank display as deleted data.
  • Environment note: This setting affects the current worksheet display.

3. Hide #N/A values and restore the display

Entry path: View tab → Hide Zero and Error Values → Hide #N/A

  1. Open the Hide Zero and Error Values menu.
  2. Select Hide #N/A.
  3. Check whether cells that previously showed #N/A are no longer displayed directly in the worksheet.
  4. To restore the display, clear Hide #N/A.

Success Criteria

  • Interface result: Cells that showed #N/A no longer display that result directly in the worksheet.
  • Next action available: You can continue editing formulas or checking references.
  • No side effect: The original formula and error source remain unchanged.

Tips While Using

  • Common mistake: Expecting other error types to be hidden at the same time.
  • Environment note: This option applies to #N/A results.