在空白单元格输入要除的数,然后复制它,选中要除的列,右键,选择性粘贴,除,确定。按上面的操作就可以了。
具体步骤
步骤1:将单元格区域A1:A10的数据除以同一个数3,并将求得的商列于单元格区域B1:B10。所有数据除以一个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/37d12f2eb9389b502246d9ac8e35e5dde6116e96?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
步骤2:在单元格B1中输入公式:=A1/3。所有数据除以一个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2cec3fdfc03924560fed8f18c94a4c27c1e2580?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d6ca7bcb0a46f21f93bc67adfd246b600d33ae47?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
步骤3:将鼠标放在单元格B1的右下角,等待鼠标标志变为一个黑色的小十字,这时按下鼠标左键,往下拖到单元格B10,最后松开鼠标左键。所有数据除以一个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3812b31bb051f81972633ab4d1b44aed2f73e78e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/95eef01f3a292df5604695ebb7315c6035a87342?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
步骤4:这样,单元格区域A1:A10除以同一个值3的商就列在单元格区域B1:B10的对应位置了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0dd7912397dda144f888554cb9b7d0a20df4864e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)