WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to hide zero(s) in a worksheet

November 5, 2021
5.9K Views

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.