Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to hyperlink a worksheet from a worksheet containing a cell A1 having name of the sheet to be hyperlinked & friendly name.

For example I have a worksheet summary with Cell A1 having its value as "1" & I have a worksheet named "1" to be hyperlink from summary & the friendly name is same as the worksheet to be hyperlinked.

share|improve this question
This is very hard to understand - are you basically saying you want to link to a worksheet, where the hyper link name matches the work sheet name? – Dave Oct 8 '12 at 11:10

You can use the HYPERLINK function.


Here is the source for more information how to use this formula.

share|improve this answer

Your Answer


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.