Forum Discussion
Solved
How do I link a cell to another sheet in the same workbook, allowing me to view the sheet?
I have a workbook containing a list of webpages in the first sheet. I want to be able to click on a cell and be directed to that sheet/tab, viewing the entire sheet, instead of clicking through a wor...
- Hello,
You need to insert a shape into each of the sheet tabs and apply hyperlink to each of the inserted shapes.
Steps
1. In the Data sheet, Insert desired shape
2. Type in name inside the shape
3. Right click and select Link
4. Select Place in this Document
5. Under the Cell Reference, click on the Sheet tab you wanna link to (for this example, select Report)
Click OK
6. Click away to deselect the shape
7. In the Report sheet, insert desired shape
8. Name the shape as in step 2 above
9. Right-click and select Link
10 Select Place in this Document
11. Under the Cell Reference, select Data
Click OK.
12. Click away to deselect the shape
You're going to see a shape of hand whenever you hover the mouse to the shape. And when you click on Report Sheet tab shape, it will move you to the Data Sheet tab
You can do the same for other sheet tabs. This will make it easier to navigate from one sheet to another.
See the pictures attached
Randy Birch Awesome! This worked and was a quicker and easier solution. Thanks!
Thank you for sharing this, its awesome!
And for the reason why it may not work I have found the following:
This may be caused by the difference in WebApp vs Excels native Windows apps.
Your solution works beautifully in Excels normal desktop app, but not at all in the WebApp.marpme , that's more than 5 years old discussion, lot of changes in Excel from that time.
However, in general formula works in Excel for web. We only need to use Ctrl+Click; or hover the mouse and click on the link.
- This seems like the best response to me. WAY less complicated and quicker to implement.
