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

Dataset Overview

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, enter 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

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