WPS Office
Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Free download
Windows • MacOS • Linux • iOS • Android
How to hide zero(s) in a worksheet
February 13, 2023
9.0K
Views
52
1. Click Menu at the upper-left corner → Options
2. Get into the View tab in the pop-up window.
3. In the category of Window options, uncheck the Zero Values option
4. Press Enter.
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.