How to Fill Blank Cells in Excel (Easiest Way in 2025)

In this article, we will show you how to fill blank cells in Excel. Simply follow the steps below.

Fill Blank Cells in Excel

Follow the steps below on how to fill blank cells in Excel.

1. Select Cells or Range with Blank Cells

Select the cells or range where you want to fill in blank cells. This includes the entire column or specific rows. Click and drag your mouse over the range of cells that contains blank spaces. Make sure to highlight all the cells where you want to add data, including the blank ones.

2. Open Go To Dialog Box

Use the Go To Special feature to locate blank cells. Press `Ctrl + G` or `F5` to open the Go To dialog box. Once the dialog box appears, click on the “Special” button to open the Go To Special dialog box, which provides options to select specific types of cells.

3. Choose Blanks in Go To Special Dialog Box

In the Go To Special dialog box, select “Blanks” by clicking on it. Then click “OK”. This will highlight all the blank cells in your selected range, making them ready for data entry.

4. Type Data in First Highlighted Blank Cell

Type the data you want to fill into the first highlighted blank cell. With all blank cells highlighted, move to the first blank cell in your selection. Type the value or formula you want to use to fill these cells. This initial value will serve as the content for all highlighted blank cells. For example, if filling in Sales Q2 for Widget A, you might type “160”.

5. Use Ctrl + Enter to Fill All Blank Cells

Use the Ctrl + Enter shortcut to fill all selected blank cells with the same data. After entering the data in the first blank cell, hold down the `Ctrl` key and press `Enter`. This action will automatically fill all the highlighted blank cells with the value or formula you typed in the first blank cell. In this example, all blank cells for Sales Q2 have been filled with “160” respectively. You can replace these values with whatever is appropriate for your dataset.

We hope you now have a better understanding of how to fill blank cells in Excel. If you enjoyed this article, you might also like our article on ways to fix Excel files not opening or our article on how to fill blank cells with 0 in Excel.