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

November 5, 2021

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.

How to hide zero(s) in a worksheet.gif

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.