How to Hide or Display Cells with Zero Value in Selected Ranges in Excel 2007/2010?
We may get the way to hide or display cells with zero value in the entire worksheet, but if I want to hide or display the cells with zero range in the selected range, how can I do?
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10. Read more...
Classic Menu for Office: Bring Classic Menus and Toolbars of Office 2003/XP/2000 Back to Office 2007, 2010 and 2013. Read more...
To hide zero values in selected cells, follow these steps:
Step 1: Select the range you want to hide cells with zero (0) value.
Step 2:On the Home tab, click Format in the Cells group, and select Format Cells option. See screenshot (Fig.1)
Fig. 1: Format Cells in Excel
Step 3: Click Number tab and select Custom, then type 0;-0;;@ in the Type box. Click OK. See screenshot (Fig.2)
Fig.2 the dialog box of Format Cells in Excel
Note: If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.
To display zero values in selected cells, follow these steps:
Step 1: Select the cells containing the zero (0) values you want to display.
Step 2: On the Home tab, click Format in the Cells group, and select Format Cells option.
Step 3: Click Number tab and select General in the list, click OK. See screenshot (Fig.3)
Fig.3 display cells with zero value in the seected range
1. If you would like to hide or display cells with zero value in the entire worksheet, click to see more details…
2. If you want to hide rows with zero value, click to see more…