How To Fill Blank Cells With Value Above In Excel

Hi,

Could you send a dummy?

Regards

There you go
Sample.xlsx

Select the table of data and apply an AutoFilter

In the relevant column then use the dropdown next to the header to select only Blanks. In the first blank row type the formula:

=A3   (assuming column A and first blank row is row 4)

Then select the remainder of that column and press Ctrl + D. This will then fill down the remainder of the column but will only populate the visible cells.

Now if you remove the AutoFilter you will see all rows populated. The column can then be copied and pasted as values to remove the formula links.

Rob,

When I try the above solution all the blank rows will be populated with the first non blank value. I dont want to do that, I have values in other rows in the middle and the blank columns below should be filled with Value above In the cell

With the filter in place, only the visible cells will be affected thus the blank cells will be populated with the formula which copies the value of the cell above and will adjust as it is copied down to refer to the cell above.