1、首先,打开需要求绝对值的数据文档;我们知道,在EXCEL中求数值的绝对值公式是=ABS(AB3:AE13)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b7003af33a87e9509f9860021e385343faf2b4d5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、那么在需要输出绝对值的地方输入公式,这里要注意的是,输入公式后,我们一般都是按回车键来得到输出值,但是这里如果直接按回车我们得到的是乱码
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/738b4710b912c8fcd61765a3f2039245d78821f3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、求绝对值时我们需要按Ctrl+shift+回车 来得到数值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9c16fdfaaf51f3de68ae2b0a9aeef01f3a297944?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、这时我们得到的是首列首行的数值绝对值,如果要得到其他数值的绝对值,我们需要进行复制;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/54fbb2fb43166d22cbb186fa482309f79152d29e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、当然,我们可以通过鼠标左键选择单元格右下角,并按住向右拖动的方式来实现快捷复制,同样向下拖动得到其他行的值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9358d109b3de9c8223276be16281800a19d8431a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、这样我们就得到一组数据的绝对值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b90e7bec54e736d1e3a81e6695504fc2d5626921?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)