How to hide zero(s) in a worksheet

November 5, 2021

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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