Home About Contact

How to Fill Blank Cells in Excel (Step-by-Step)

Last Updated: Mon Jan 06 2025

By: Matt Hayes

In 7 easy to do steps, our guide will show you how to fill blank cells in Excel.

Managing large datasets becomes easier with the right techniques to quickly and efficiently fill blank cells.

So let’s dive in and fill in the blanks in Excel!

Steps:

Select the Data Range
Open the Go To Dialog Box
Access the Go To Special Dialog Box
Select Blank Cells
Enter the Desired Value
Fill Blank Cells with Formulas
Review and Adjust Your Data

Step 1: Select the Entire Data Range

First, identify the data range that contains blank cells. Click and drag your mouse to highlight the entire range. Ensure all cells, including blanks, are selected.

highlights the rata range that including blank cells

Next step

Step 2: Press F5 to Open the Go To Dialog Box

To open the Go To dialog box, press the F5 key on your keyboard. Alternatively, navigate to the Home tab, find the Editing group, click on Find & Select, and choose Go To.

Back Next step

Step 3: Go To the ‘Special’ Dialog Box

In the Go To dialog box, click on the Special button.

This will open the Go To Special dialog box.

Back Next step

Step 4: Select Blank Cells and Click on ‘OK’

Within the Go To Special dialog box, select Blanks and click OK. This action will highlight all the blank cells in your selected data range.

Back Next step

Step 5: Enter the Desired Value to Fill Blank Cells

Once the blank cells are selected, you can enter the value you want to fill the blank cells with. For example, if you want to enter "Not Available", type it in the active cell (highlighted in white).

And hold down the Ctrl key while pressing Enter. This will fill all selected blank cells with the entered value.

Back Next step

Step 6: Alternatively, Fill Blank Cells with Formulas

If you prefer to fill blank cells with formulas, such as referencing the cell above, type the formula in the active cell. For example, type =B2 to copy the value from the cell above. Hold down the Ctrl key and press Enter to apply the formula to all blank cells.

Back Next step

Step 7: Review and Adjust Your Data

After filling the blank cells, review your data to ensure accuracy. Make any necessary adjustments to ensure the dataset meets your requirements.

red rectangle highlights ensure that there is no blank cells left

And that’s it! That’s how you fill blank cells in Excel.

Back

Finished!

Conclusion

Filling blank cells in Excel is a straightforward process when using the Go To Special feature.

By following these steps, you can efficiently manage your data and maintain consistency across your datasets.