Linking a cell to a tab within an Excel workbook
Solution 1
I don't have a Mac on which to test this but I believe the instructions here are what you need:
-
Right click on the cell where the hyperlink should go and select Hyperlink from the popup menu.
-
Click on the Documents tab then the Locate button.
-
Enter the cell reference that the hyperlink should point to. Adjust the sheet name appropriately.
You should now see something like the following:
-
Enter the hyperlink text in the Display field.
You'll end up with something like this:
Solution 2
=SheetName!CellReference
Example: =Sheet1!A1
This would link whatever cell you type this in to cell A1 on Sheet1, assuming your workbook has a Sheet1.
Related videos on Youtube
nick_name
Updated on September 18, 2022Comments
-
nick_name almost 2 years
I'm using Microsoft Excel 2011. One of my workbooks contains a tab. I want that tab to open when I click a link. The link should be in a cell in the same workbook. How can I create such a link?
-
soandos almost 13 yearsCan you explain you question more?
-
-
nick_name almost 13 yearsIs it possible to have text in the cell + the link?
-
nick_name almost 13 yearsActually, this is not what I'm looking for. I want the tab to open when I click the link.