How to Fill Blank Cells with Text in Excel (3 Methods)

Let’s start with our sample dataset, which contains several blank cells. Our objective is to fill these blank cells with text.

Steps:

Select the entire dataset (B5:F12) where you need to fill blank cells.
Go to the Home tab, and from the Editing group, click on the Find & Select drop-down menu.
Choose Go To Special option. A dialog box will appear.

Select the Blanks option under the Select section and press OK. This will select all of the blank cells.

In the first blank cell, type the text you want to fill the blank cells with (for example, Void). Press CTRL+ENTER.

All the blank cells will now be filled with the same word Void.

Steps:

Leave the Find what box blank and type Void in the Replace with box.
Click Replace All to fill in the blank cells with Void.

Steps:

Go to the Developer tab and click the Visual Basic button.
In the window that pops up, click the Insert tab and select the Module option.

If you don’t have this tab, enable it, or press Alt+F11 to open a new module.

Sub FillBlankCells()
Range("B5:F12").SpecialCells(xlCellTypeBlanks) = "Void"
End Sub

Quick Notes

Save your Excel file in .xlsm format to retain the macro and run the VBA code effectively.

Download Practice Workbook

You can download the practice workbook from here:

Fill Blank Cells with Text.xlsm