:Quick filling of discontinuous cells-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Quick filling of discontinuous cells

Quick filling of discontinuous cells

Author: daogeziyuan • • Table skills • Views 804
  • Image and text skills


When using WPS for office work, sometimes you need to quickly fill in discontinuous empty cells. How to do this?


3592b69993a8f8fe8457be47405e9cd8.png


￭For example, in this table, we need to fill in the empty cells in column A;


图一.png


￭Select data area A2-A21 and find "Smart Toolbox" in the menu bar

[Students who cannot find it, please check whether the version you are currently using is the latest 2019 version]


图二.png


￭Click "Data Entry" and select "Fill Blank Cells",


图三.png


￭Select the fill value in the pop-up window according to the situation. I chose "Default is the same as the value above" and click "OK";


图四.png


￭ can complete the data filling of discontinuous cells.


图五.png


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/bu-lian-xu-dan-yuan-ge-kuai-su-tian-chong.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu Linc Columnist
48 196
single-end

Related Suggestion