MS Excel 2011 for Mac: Create a hyperlink to another cell
This Excel tutorial explains how to create a hyperlink to another cell in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: I want to create a hyperlink in Microsoft Excel 2011 for Mac. How do I specify a particular location that a hyperlink should point to?
Answer: To create a hyperlink to another cell in your spreadsheet, right click on the cell where the hyperlink should go. Select Hyperlink from the popup menu.
When the Insert Hyperlink window appears, click on the Document tab. Then click on the Locate button.
When the Select Place in Document window appears, enter the cell reference that the hyperlink points to. We've chosen to link to cell A5. Click the OK button.
When you return to the Insert Hyperlink window, you should see the following:
Next in the Display field, enter the text that you wish to display in Excel. In this example, we've entered "Hyperlink to cell A5". Click on the OK button.
If you click on the hyperlink, your active cell should become cell A5.
Advertisements