When working with a Microsoft Excel workbook, you often need to use documents prepared in various MS Office applications. For example, by adding hyperlinks to worksheets, you can move between these documents with a single mouse click.
To create a hyperlink to another MS Office document (including the current workbook, but to a different cell range or another worksheet) in an MS Excel worksheet:
- Select the range or shape to which the hyperlink will be attached.
- Go to the Insert tab on the ribbon and, in the Links group, click the Hyperlink button.
- In the Insert Hyperlink window, set the necessary options. The switches File, Web Page, Place in This Document, Create New Document, Email Address in the Link to group specify the document that the hyperlink will point to. The Text to Display field specifies the hyperlink text. In the Look in field, choose the folder that contains the desired document. From the lists Current Folder, Browsed Pages, and Recent Files, you can select the required file. In the Address drop-down list, you can specify the document’s URL. The ScreenTip button allows you to add text to the hyperlink’s tooltip, and the Bookmark button lets you choose a specific location to which the hyperlink will jump.
- After setting the required parameters, click OK.
You can edit a hyperlink by right-clicking on it. A context menu will appear with three commands for working with hyperlinks:
- Edit Hyperlink — opens the Edit Hyperlink window, where you can change the path to the linked file and its name, as well as add an explanatory note to the hyperlink;
- Open Hyperlink — opens the linked document, just as if you clicked the hyperlink;
- Remove Hyperlink — deletes the hyperlink.