Articles → EXCEL → How To Select Empty Cells In Excel Worksheets

How To Select Empty Cells In Excel Worksheets

In this article, we will see how to select the empty cell in excel.

Scenario

Consider the following excel sheet

Picture showing the sample excel with empty cells

Click to Enlarge

Here the job is to check if the employee is coming for a movie or not. Based on the employee response, column B needs to be filled.

Here some status is filled so the excel would be

Picture showing the sample excel with some values are filled in the column

Click to Enlarge

In the pending columns requirement is to fill ‘No’ with minimal effort.

Fill Empty Cells

Follow these steps

Select column B.
Press CTRL + G. Following window will appear.

Picture showing the Go to window when user presses CTRL + G

Click to Enlarge

Click on the ‘Special…’ button. Following window will come.

Picture showing the window that appears when user clicks on the Special.. button

Click to Enlarge

Select ‘Blanks’ and click on ‘Ok’.
All the empty cells got selected as shown in figure below.

Picture showing selecting the empty cells of the column

Click to Enlarge

In the above figure, the focus in on first empty cell. Enter the value ‘No’.
Press CTRL + Enter.

Output

Picture showing filling the value of empty cells to No

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, November 2, 2018

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**