1、演示使用的软件为OfficeExcel,使用的版本为MicrosoftOffice家庭和学生版2016。
/iknow-pic.cdn.bcebos.com/9358d109b3de9c822e30569c6281800a19d84348"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9358d109b3de9c822e30569c6281800a19d84348?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/9358d109b3de9c822e30569c6281800a19d84348"/>
2、首先打开Excel电子表格,新建表格文档。
/iknow-pic.cdn.bcebos.com/d4628535e5dde7117190ece5a9efce1b9d166167"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d4628535e5dde7117190ece5a9efce1b9d166167?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/d4628535e5dde7117190ece5a9efce1b9d166167"/>
3、删帖我们复制的网址链接,这里我们选用百度官网为例演示,可以看到此时粘贴进来的网址并没有被Excel识别。
/iknow-pic.cdn.bcebos.com/cf1b9d16fdfaaf511b7d2eac825494eef01f7a03"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/cf1b9d16fdfaaf511b7d2eac825494eef01f7a03?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/cf1b9d16fdfaaf511b7d2eac825494eef01f7a03"/>
4、此时我们右键单击该单元格,然后在弹出的菜单中选择链接菜单。
/iknow-pic.cdn.bcebos.com/b21bb051f81986185296409744ed2e738ad4e6d4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b21bb051f81986185296409744ed2e738ad4e6d4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/b21bb051f81986185296409744ed2e738ad4e6d4"/>
5、紧接着在弹出的插入超链接窗口中,我们将要显示的文字,也就是网址,复制粘贴到下方的地址栏中,然后点击确定即可。
/iknow-pic.cdn.bcebos.com/4e4a20a4462309f7035303017c0e0cf3d7cad6e1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/4e4a20a4462309f7035303017c0e0cf3d7cad6e1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/4e4a20a4462309f7035303017c0e0cf3d7cad6e1"/>
6、可以看到点击确定后,我们粘贴进来的网址链接现在已经包含超链接了,点击即可自动跳转到链接页面。
/iknow-pic.cdn.bcebos.com/9d82d158ccbf6c8182f983fbb23eb13532fa40d2"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9d82d158ccbf6c8182f983fbb23eb13532fa40d2?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/9d82d158ccbf6c8182f983fbb23eb13532fa40d2"/>