为什么excel拖拉填充的图标会变成复制?

发布网友发布时间：2024-09-26 20:09

共1个回答

热心网友时间：2024-10-05 12:00

因为没有设置填充公式，在没有设置公式的情况下，向下拖动图标excel会自动定义为复制，手动设置需要的填充公式即可正常填充，具体步骤如下所示。
1、打开excel文件，选中需要填充的单元格之后点击上方工具栏中的开始选项卡。
/iknow-pic.cdn.bcebos.com/1e30e924b899a9015fb8926b13950a7b0308f5da"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/1e30e924b899a9015fb8926b13950a7b0308f5da?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/1e30e924b899a9015fb8926b13950a7b0308f5da"/>
2、在工具栏中点击填充选项卡打开下拉菜单。
/iknow-pic.cdn.bcebos.com/94cad1c8a786c917ceb99b64c73d70cf3bc75731"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c917ceb99b64c73d70cf3bc75731?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/94cad1c8a786c917ceb99b64c73d70cf3bc75731"/>
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/94cad1c8a786c917cea19b64c73d70cf3ac757c9"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/94cad1c8a786c917cea19b64c73d70cf3ac757c9?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/94cad1c8a786c917cea19b64c73d70cf3ac757c9"/>