Wednesday, January 25, 2017

Find blank cells in a range

Find blank cells in a range

  1. Select the range of cells where you want to search.

  2. On the Edit menu, click Go To.

  3. Click Special.

  4. Select Blanks, and then click OK.

    The blank cells in the range are selected.

See also

About filtering

Ways to count cells in a range of data

No comments:

Post a Comment