当前位置：网站首页>Excel quickly and automatically fills the contents of a row on a blank cell

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

2022-04-23 17:11:00 【ZHZHK001】

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 .

版权声明
本文为[ZHZHK001]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230553251339.html