How to hide zero(s) in a worksheet
November 5, 2021
3.5K
Views
0
0
A free Office suite fully compatible with Microsoft Office
Free Download
A free Office suite fully compatible with Microsoft Office
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.
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel