How to Add Links in Excel

出自freem
於 2023年3月21日 (二) 15:59 由 Lukegao1對話 | 貢獻 所做的修訂 (创建页面,内容为“You can add links in Excel to easily navigate to other sheets or workbooks, or to open external files or websites. Here are the steps to add links in Excel: 1. Select the cell or object where you want to add the link. 2. Right-click the selected cell or object and choose "Hyperlink" from the context menu. Alternatively, you can go to the "Insert" tab in the Ribbon, click "Hyperlink" in the "Links" group, and then select the type of link you want to add. 3. In…”)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

You can add links in Excel to easily navigate to other sheets or workbooks, or to open external files or websites. Here are the steps to add links in Excel:

1. Select the cell or object where you want to add the link. 2. Right-click the selected cell or object and choose "Hyperlink" from the context menu. Alternatively, you can go to the "Insert" tab in the Ribbon, click "Hyperlink" in the "Links" group, and then select the type of link you want to add. 3. In the "Insert Hyperlink" dialog box, choose the type of link you want to add from the options on the left. You can choose from "Existing File or Web Page", "Place in This Document", "Create New Document", "E-mail Address", or "Link to File". 4. Depending on the type of link you choose, you may need to provide additional information, such as the file path, document name, or URL. 5. Click "OK" to create the hyperlink. The selected cell or object will now be underlined and formatted in a different color to indicate that it contains a hyperlink.

To follow a hyperlink, simply click on the linked cell or object. If you want to edit or remove a hyperlink, right-click the cell or object and choose "Hyperlink" from the context menu. In the "Edit Hyperlink" dialog box, you can change the link's properties or remove the link altogether.