Excel Guides

Displaying a Count of Zeros on the Status Bar in Excel

When working with large amounts of data in Microsoft Excel, it can be helpful to display a count of the number of cells that contain zero values on the status bar. This can give you a quick way to see how many cells in your worksheet contain no data.

To display a count of zeros on the status bar, follow these steps:

  1. Select the range of cells that you want to check for zeros.
  2. On the Home tab, in the Editing group, click Find & Select.
  3. Click Go To Special.
  4. In the Go To Special dialog box, click Constants, and then click OK.
  5. On the Home tab, in the Editing group, click Find & Select.
  6. Click Replace.
  7. In the Find what box, type 0, and then click Replace All.

Note:

This replaces all zeros in your selection with blanks. If your data contains any other numbers besides zeros (such as 1 or 2), those numbers will also be replaced with blanks.

You can use this technique to count any type of data in your worksheet. For example, to count the number of cells that contain text, follow these steps:

  1. Select the range of cells that you want to check for text.
  2. On the Home tab, in the Editing group, click Find & Select.
  3. Click Go To Special.
  4. In the Go To Special dialog box, click Constants, and then click OK.
  5. On the Home tab, in the Editing group, click Find & Select.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.