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:
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
