How to Hide Zero and Error Values in WPS on macOS

Last updated:July 20, 2026

Use Hide Zero and Error Values through 3 how-to topics, all available without membership, and jump to the exact task from the How-to Index.

How-to Index

No.TopicMembership
11. Open the Hide Zero and Error Values menuFree
22. Hide zero valuesFree
33. Hide error values with Hide #N/AFree

How-to Guide

1. Open the Hide Zero and Error Values menu

Entry path: View → Hide Zero and Error Values

  1. Open the spreadsheet you want to adjust.
  2. Click the View tab at the top of the window.
  3. Find Hide Zero and Error Values on the toolbar and click it.
  4. Check the drop-down menu and confirm that it includes Hide Zero Values and Hide #N/A.

Success Criteria

  • Interface result: the drop-down menu opens and shows two selectable options.
  • Next step available: you can select either option to change the worksheet display.

Tips While Using

  • Common mistake: if you are not in an editable spreadsheet view, the entry may not be available right away.

2. Hide zero values

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

  1. Open the Hide Zero and Error Values menu.
  2. Select Hide Zero Values.
  3. Check whether cells with a value of 0 now appear blank in the current worksheet.
  4. Clear Hide Zero Values if you want to restore the original display.

Success Criteria

  • Interface result: cells with 0 no longer show the number in the current worksheet.
  • Next step available: you can continue editing, saving, or using other display options.
  • No side effect: the original data and formula results remain unchanged.

Tips While Using

  • Common mistake: a blank-looking cell may be mistaken for deleted data, but only the display is hidden.

3. Hide error values with Hide #N/A

Entry path: View → 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 showing #N/A are now hidden in the current worksheet.
  4. Clear Hide #N/A if you want to restore the original display.

Success Criteria

  • Interface result: #N/A display items are hidden in the current worksheet.
  • Next step available: you can keep reviewing data or combine this with hidden zero values.
  • No side effect: the original formulas and data are not changed.

Tips While Using

  • Common mistake: this option applies to #N/A only and does not hide every error type.