How to Fill Blank Cells in Excel with Data from Above: Step-by-Step Guide and Formula

You can use the “Fill” feature in Excel to fill blank cells with information from the cells above. Here’s how:

1. Select the range of cells that contains the blank cells you want to fill.
2. Click on the “Home” tab in the ribbon at the top of the Excel window.
3. Click on the “Find & Select” button in the “Editing” section of the ribbon, and select “Go To Special…” from the dropdown menu.
4. In the “Go To Special” dialog box, select “Blanks” and click “OK”. This will select all of the blank cells in the range.
5. Type in the equal sign “=” and then click on the cell above the first blank cell in the range.
6. Press “Ctrl” + “Enter” on your keyboard. This will fill all of the selected blank cells with the value from the cell above.

Alternatively, you can use a formula to achieve the same result. Here’s an example:

1. In a new column next to the column with the blank cells, enter the following formula in the first cell: =IF(A2<>””,A2,B1)
2. This formula checks if the cell in column A is not blank. If it is not blank, it copies the value from column A to the new column. If it is blank, it copies the value from the cell above in the new column.
3. Copy this formula down to all the cells in the new column.
4. Finally, copy the values in the new column and paste them back into the original column to replace the blanks with the copied values.