How to hide zero(s) in a worksheet

November 5, 2021
1,308 Views 0

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

Was this helpful?