Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink to Specific Excel Cell? (2K/03)

    Hello everyone,

    Anyone know of a way to create a hyperlink on PowerPoint slide that takes me to a specific cell on a specific Excel worksheet?

    I know how to create a link to an Excel workbook, but I want the hyperlink to take me at least to a specific worksheet.

    Thanks so much,
    Rich

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Hyperlink to Specific Excel Cell? (2K/03)

    Start by creating a hyperlink to the workbook the normal way.
    The address of the hyperlink will look like this: <code>C:ExcelWorkbook.xls</code>
    Then edit the address to look like this: <code>C:ExcelWorkbook.xls#Sheet1!C19</code>
    These are just examples, of course. Substitute the appropriate names.
    If the sheet name contains spaces, enclose it in single quotes: <code>C:ExcelWorkbook.xls#'April Data'!C19</code>

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Vancouver, Washington, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink to Specific Excel Cell? (2K/03)

    Hi Hans,

    But, of course! Thanks so much, it's like an HTML a tag href to an anchor! If you have a define Name in a Workbook, using the Name rather than a cell reference works as well.

    As always, you're a great help, and met the training needs of my client exactly. I am assuming that works in a Word hyperlink in exactly the same way?

    Thanks and best regards,
    Rich

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Hyperlink to Specific Excel Cell? (2K/03)

    Yes. For a hyperlink to a Word document, you'd add # and the name of a valid bookmark after the file name.

Posting Permissions

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