How to use the positioning function in Excel to realize rapid filling

Select the data columns to fill in the table.

Click Edit in the menu bar, then click Positioning (or press F5 or Ctrl+G to open Positioning), and then click Positioning Criteria.

How to use the positioning function in Excel to realize rapid filling

three

Open the interface shown in the figure below, select "null value" and click "OK".

How to use the positioning function in Excel to realize rapid filling

four

Enter "=A3" in the bulletin board (this is input according to the actual situation), as shown in the following figure.

How to use the positioning function in Excel to realize rapid filling

five

Then press and hold the Ctrl key and enter to complete the filling, and the effect is shown in the following figure.

How to use the positioning function in Excel to realize rapid filling