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

When creating links to Excel files it is possible to add a fragment to the URL in order to specify a specific location (e.g. a certain sheet) which should be opened when the link is followed. See, for example, this question here on SU.

I am looking for a detailed documentation just what types of fragments are possible (e.g. ranges, named ranges, ...). Google & Co didn't help much, since all the results are about linking the content of cells between different Excel sheets (which is not what I'm after).


In a link, what are valid values for fragment?

share|improve this question
up vote 1 down vote accepted

Yes, it is documented by Microsoft in Article ID: 197922 which covers what you are trying to do. Basically, after the # you place the tab name then !followed by the cell reference.!A1

If you are doing this in HTML of course you will use...

<a href="!A1"> This link will open the Excel file to the named tab with the focus on cell A1</a>.

share|improve this answer
Wonderful, thank you! – Florian Brucker Feb 9 '12 at 8:01
You are welcome. Glad to help. – CharlieRB Feb 9 '12 at 14:22

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.