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

How To Select Empty Cells In Excel Worksheets






Scenario




Picture showing the sample excel with empty cells
Click to Enlarge





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




Fill Empty Cells




  1. Select column B.
  2. Press CTRL + G. Following window will appear.
  3. Picture showing the Go to window when user presses CTRL + G
    Click to Enlarge

  4. Click on the ‘Special…’ button. Following window will come.
  5. Picture showing the window that appears when user clicks on the Special.. button
    Click to Enlarge

  6. Select ‘Blanks’ and click on ‘Ok’.
  7. All the empty cells got selected as shown in figure below.
  8. Picture showing selecting the empty cells of the column
    Click to Enlarge

  9. In the above figure, the focus in on first empty cell. Enter the value ‘No’.
  10. 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/FeedbackCharacters remaining 250