How to autofill values in below blank cells using excel

Tools
1

Hi All,
Issue:- During excel work, We need to fill values(first upper non-blank cell value) automatically in a blank cell.

image

Root Cause:-Main issue blank cells are in randomely possition, so symetric or pattern.

Solution:- https://www.youtube.com/watch?v=9M6O5sfKqkk

2

1- copy the value of the first cell
2- select the area were the blank cells should be filled
3- Go to Home → find and replace → replace → replace then:
find what: empty
Replace with: past the first cell value “A” for example.

Then Done :slight_smile:

3

Thanks @Fouad_Abu_Jasser

But it will fill “A” in every empty cell.

Note:- Empty cell must be follow immediate upper no-empty cell value.

image