1.

How Can You Select All Blank Cells In Excel?

Answer»

If you work with a DATA SET that has blank cells in it, you can easily select these cells in Excel. Once selected, you can choose to highlight these, DELETE these, or add some value to it (such as 0 or NA).

To do this, you need to use the Go To Special dialog box in Excel.

Here are the steps to select all blank cells in Excel:

  • Select the entire data set (including blank cells).
  • Press F5 (this OPENS the Go to dialog box).
  • Click the 'Special' button (this opens the Go To special dialogue box).
  • Select Blanks and click OK (this SELECTS all the blank cells in your data set).

If you work with a data set that has blank cells in it, you can easily select these cells in Excel. Once selected, you can choose to highlight these, delete these, or add some value to it (such as 0 or NA).

To do this, you need to use the Go To Special dialog box in Excel.

Here are the steps to select all blank cells in Excel:


Discussion

No Comment Found

Related InterviewSolutions