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? 

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

Tip:

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…

Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.