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.

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

So:

In a link http://somehost.com/some_excel_file.xls#fragment, what are valid values for fragment?

share|improve this question
add comment

1 Answer

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.

http://somehost.com/some_excel_file.xls#TabName!A1

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

<a href="http://somehost.com/some_excel_file.xls#TabName!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
add comment

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.