How to hide zero(s) in a worksheet
September 14, 2026
12.8K
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.
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
