Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2008
    Thanked 0 Times in 0 Posts

    Set up "table of contents" and jump to location (Excel 2007)

    I have a spreadsheet that has some useful formatting that I use in reports. (In this case it is showing the calculation of molecular weight of a compound). I would like to have an index in column 1, listing the range name and clicking on it, allowing a jump to that range.

    I am sure that it has been done before, but I cannot find the correct search terms find it.
    [I have been here for years; I had to get things restarted]

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    I do this with HYPERLINK. You will have to include the name of the workbook:
    The second "A1" is the display name, you can use a different cell if desired. If no "friendly name" is added it will display the link.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts