1、演示使用的工具是office Excel,使用的版本为office家庭和学生版2016,其他版本的操作方法一致。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/359b033b5bb5c9eaa00aa2c9db39b6003af3b31b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建一张Excel表格,并在表格的A505和A265输入演示所用的值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2f738bd4b31c8701d18012cc297f9e2f0708ffe2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后我们再表格的左上方找到一个输入框,该位置默认状态下显示的是当前选中单元格的坐标,我们单击后就会变成输入框模式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4a36acaf2edda3cca9e9180a0fe93901213f928f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、然后在该输入框中输入A265,A代表列,265代表行,该坐标表示A列的第265行。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d058ccbf6c81800a11982924bf3533fa828b479e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、输入完成之后点击键盘上的回车键,可以发现当前单元格已经定位到了第265行A列,同样的,我们可以在坐标显示框中输入A505,然后单击回车,单元格就会自动定位到A505单元格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/960a304e251f95cac495329cc7177f3e670952b3?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/b3fb43166d224f4ab621d33907f790529822d164?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)