Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    London, Middlesex, England
    Thanked 0 Times in 0 Posts

    Hyperlinking to a table


    My Excel file has many tables, one under the other.
    I've made like a Contents Page at the top where you can click to goto a particular table.

    Problem is, document is changed, so tables get moved up or down.
    So the hyperlinks must be manually updated each time.

    I remember solving this problem in Word by inserting Bookmarks & then linking to them. Also in Word, you can link to a specified Heading.

    Can I do a similar thing in Excel

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Re: Hyperlinking to a table

    The equivalent in Excel is to use range names.
    Goto the table that you want to jump to and select "Insert>Name>Define" to create the range name. In the contents page, when you create the hyperlink and specify "a place in the document" you can then choose one of the defined names from the list.

Posting Permissions

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