Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
Can you explain you question more? –  soandos Aug 30 '11 at 20:41

2 Answers 2

up vote 2 down vote accepted

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.

    enter image description here

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

    enter image description here

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

    enter image description here

    You should now see something like the following:

    enter image description here

  4. Enter the hyperlink text in the Display field.

    enter image description here

    You'll end up with something like this:

    enter image description here

share|improve this answer
=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.

share|improve this answer
    
Is it possible to have text in the cell + the link? –  nick_name Aug 30 '11 at 20:51
    
Actually, this is not what I'm looking for. I want the tab to open when I click the link. –  nick_name Aug 30 '11 at 20:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.