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

Often you may want to fill blank cells in an Excel spreadsheet with the values in the cells directly above them.

For example, you may want to fill in blank cells in the following dataset:

Excel fill blank cells

Fortunately this is easy to do using the Go To Special tool in Excel and the following step-by-step example shows how to do so.

Step 1: Enter the Data

First, let’s enter values for the following dataset in Excel:

Step 2: Select All Blank Cells

Next, highlight the cell range A1:B13 and then click the Find & Select icon in the Editing group of the Home tab, then click Go To Special from the dropdown menu:

In the new window that appears, click the button next to Blanks, then click OK:

Once you click OK, all of the blank values in the range will be selected:

Step 3: Fill in All Blank Cells

With all of the blank cells still selected, type “=” and then type the up arrow on your keyboard.

Then click Ctrl + Enter at the same time.

Each of the blank cells will be filled:

Notice that all blank cells in the Team and Player columns have been filled in with the appropriate value of the cells above them.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Ignore #N/A Values When Using Formulas in Excel
How to Replace #N/A Values in Excel
How to Fix the #NAME Error in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *