excel下拉拖动时出现复制怎么办?
发布网友
发布时间：2024-09-27 15:40
共1个回答
热心网友
时间：9分钟前
因为没有设置填充公式，在没有设置公式的情况下，向下拖动图标excel会自动定义为复制，手动设置需要的填充公式即可正常填充，具体步骤如下所示。
1、打开excel文件，选中需要填充的单元格之后点击上方工具栏中的开始选项卡。
/iknow-pic.cdn.bcebos.com/1e30e924b9a9015fb26b13950a7b0308f5da"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/1e30e924b9a9015fb26b13950a7b0308f5da?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/1e30e924b9a9015fb26b13950a7b0308f5da"/>
2、在工具栏中点击填充选项卡打开下拉菜单。
/iknow-pic.cdn.bcebos.com/94cad1c8a786c917ceb99bc73d70cf3bc75731"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c917ceb99bc73d70cf3bc75731?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/94cad1c8a786c917ceb99bc73d70cf3bc75731"/>
3、在弹出的下拉菜单中点击序列选项卡。
/iknow-pic.cdn.bcebos.com/5fdf8db1cb1349549fab2139584e9258d1094a32"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/5fdf8db1cb1349549fab2139584e9258d1094a32?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/5fdf8db1cb1349549fab2139584e9258d1094a32"/>
4、在弹出的序列设置菜单中选择需要填充的应用公式点击确认即可。
/iknow-pic.cdn.bcebos.com/94cad1c8a786c917cea19bc73d70cf3ac757c9"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c917cea19bc73d70cf3ac757c9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/94cad1c8a786c917cea19bc73d70cf3ac757c9"/>
