Fill Blank Cells with Above Value in Excel

Let’s assume that your sheet contains a lot of blank cells under the heads in a particular column. Now you want to pick up these blank cells from the range and select them.

Of course, you can select each blank cell one by one manually, which may be time-consuming and tedious

Here I will introduce a couple of tricks to quickly select all blank cells using Go-To Special and fill these up with their headers.

To Fill Blank Cells with Above Value in Excel follow the steps given below:

1. Select the affected columns in which there are blank cells

2. Press the Shortcut Key Ctrl + G

3. Click on Special Button

4. Choose the Blank option and click on Ok

Note – All the blank cells in the affected columns will be selected after clicking on OK

5. After pressing OK instantly press equal to (=) key in the cell

6. Press the up arrow key and instantly press the Shortcut key Ctrl + Enter

Note – After pressing the up arrow key it will automatically choose the above cell in the selected column

7. Lastly you will see all the blank cells have been filled with the values in Excel

Now all these cells are based on a formula so, if the starting cell is deleted, then the below cell will be converted into 0. So to convert from formula to values, use Paste Special Value by following the steps given below:

8. Select the affected columns in which there are blank cells and press right-click

9. After right-clicking the entire column click on Copy

10. Now again right-click on the same affected column and go to Paste Special and select the Paste Value option

11. Lastly you will see all the cells have been converted from formula to values







Download 101 Ultimate Excel Formulas Guide