1、本次使用办公软件Excel 2013版本,演示如何在Excel中把表格中的所有数字乘以相同的一个数的操作。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b58f8c5494eef01f252645bdeefe9925bc317d93?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建一个Excel表格,在表格中A列填入作为演示操作的任意数字。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d833c895d143ad4ba75e1bb88c025aafa40f0651?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、选中B1单元格,然后鼠标点击插入函数”fx“。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c75c10385343fbf25fcffb5bbe7eca8064388fe3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在插入函数菜单栏中选择函数类别“数学与三角函数”,选择函数”ABS“,单击确认。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/42166d224f4a20a4850e60bf9e529822720ed0b2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在函数参数菜单栏中输入“A1*10”(这里统一乘以数字10,10是举例数字。),单击确认。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494eeeda4536123f5e0fe98257ec7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、得到的函数就显示在B1单元格内,将鼠标放在B1单元格右下角呈实心十字架状后按住鼠标往下拖动。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b60dcb9ed0ce5f81a4c510fa217?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、这样就可以看到A1列单元格的数字全部统一乘以了同一个数。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b55b319ebc4b745c69be86ec1fc1e178a8215be?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)