第1个回答 2019-07-06
1、新建空白excel文档,选择”插入“
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/6159252dd42a2834860e90ee55b5c9ea14cebfaf?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/3b87e950352ac65cafadc096f5f2b21192138aaf?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/b2de9c82d158ccbf64f113df17d8bc3eb0354181?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/472309f790529822efc99f26d9ca7bcb0b46d459?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/622762d0f703918f2d799b2f5f3d269758eec4af?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/8c1001e93901213f64b7e8395ae736d12e2e954b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、这样就成功的将多个excel工作表中快速跳转到指定表了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dc54564e9258d109b7ae0f57df58ccbf6d814d81?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
本回答被网友采纳
第2个回答 推荐于2017-10-06
通过超级链接实现:
一、新建一个工作表,作为目录,列举全部工作表名称及用途,然后设置超级链接;
二、在其他每一个工作表的指定位置设置一个“返回”目录的链接。
这样,通过“目录”这个中转表,快速跳到相应工作表本回答被提问者采纳
第3个回答 2016-08-11
在左下角选工作表的的三角指示上右键点击选指定的工作表;
第4个回答 2017-10-05
通过超级链接实现:一、新建一个工作表,作为目录,列举全部工作表名称及用途,然后设置超级链接;二、在其他每一个工作表的指定位置设置一个“返回”目录的链接。这样,通过“目录”这个中转表,快速跳到相应工作表