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?

1

2 Answers

I don't have a Mac on which to test this but I believe the instructions here are what you need:

1. Right click on the cell where the hyperlink should go and select Hyperlink from the popup menu.

2. Click on the Documents tab then the Locate button.

3. Enter the cell reference that the hyperlink should point to. Adjust the sheet name appropriately.

   You should now see something like the following:

4. Enter the hyperlink text in the Display field.

   You'll end up with something like this:

=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.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy