Ways to populate Non-empty cell data above Excel tables

Ways to populate Non-empty cell data above Excel tables

1. Selection Range

Select the empty cell that you want to fill in and the cell above it.

2, positioning null value

Press ctrl+g at the same time, jump out of the "Positioning" dialog box, click "Positioning conditions"

In the "Locate condition" dialog that pops up, select "Null value" and make sure that the blank cell is all selected

3. Input formula

Enter the address of the cell above the "=" and the first empty cell (A2), as shown below, when the input is complete, press and hold ctrl+enter at the same time