Site icon Professor Excel

How to Select All Blank Cells in Excel

blank, cells, blank cells, select, excelWhen you work with data, you often want to select certain cells, for example all blank cells. You might want to fill them or just mark them. In this article we’ll learn how to select all empty cells.

 

How to select all blank cells

Using “Go To Special” could be helpful:

  1. Select the range of cells you want to work with, also cells with content. 
  2. Go to “Find & Select” in the Home ribbon. 
  3. Click on “Go To Special”.
  4. Select “Blanks”.
  5. Click “OK”.

Now, you can work with all the empty cells at the same time as they are marked. If you want to fill them with text – let’s say “Empty Cell”, type “Empty Cell”. Instead of just pressing Enter, press “Ctrl + Enter”. Now all previously empty cells show the text “Empty Cell”.

 

Example: How to fill each empty cell with the content from the next not blank cell above 

Let’s have a look at an example: Oftentimes, you got a column of data as shown in the picture above. In column C you can see the color of cars. Now we want to copy the color from the next filled cell above to each blank cell below so that it says ‘Red’ in cell C4; C5 should stay with blue whereas C6 and C7 should say Blue as well.

Exit mobile version