Quickly show or hide zero values in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Sometimes, the zero values are hidden in a specific worksheet in Excel, and now you want to show the zero values, how can you do? Certainly, you can go to the Excel options to set the option with File > Options > Advanced > Display options for this worksheet > Show a zero in cells that have zero value, but it is a little troublesome if you want to toggle show and hide zero values frequently in Excel. Kutools for Excel’s Show Zero utility can do you a favor on the quickly toggle showing and hiding zeros with only one click in Excel.
Show or hide zero values in Excel
Click Kutools Plus >> Worksheet Design >> Show Zero. See screenshot:
 |
 |
 |
Show or hide zero values in Excel
To enable showing zero values, you just need to click Kutools Plus > Worksheet Design, then under Design tab, check Show Zero check box. Then the zero values are shown in active worksheet.
To enable hiding zero values, you just need to click Enterprise > Worksheet Design, then under Design tab, keep Show Zero check box unchecked. Then the zero values are hidden in the cell.
Tip:
1. The Show Zero utility works for the whole worksheet.
2. You can click Close Design to close the Design Tab in the Ribbon.
Demo: Quickly show or hide zero values in Excel
Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
