Excel quickly and automatically fills the contents of a row on a blank cell

Excel
WPS2019 The verification is successful

1、 Select data area

2、 Select a null value in the positioning condition

Press Ctrl+G、Ctrl+F perhaps F5 Call up the positioning dialog box , Click... In the lower left corner 【 Location condition 】.

stay 【 Location condition 】 Choose from 【 Null value 】, And then click 【 determine 】 Button .

After following the above operation , All blank cells are selected .

3、 Press... Directly on the keyboard “=” key （ Be careful ： Instead of going to the formula bar to enter ）

4、 Then press the up arrow key on the keyboard , That is to say ↑

5、CTRL+ enter

Hold it with your left hand Ctrl, Click with your right hand Enter All the filling is completed quickly .