Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    View Hyperlink Address (Excel 97)

    I need to view the hyperlinks full address in Excel 97 worksheet. For instance, the cell says howard, but the link is http:howard.comindex.html. Is there a command to view the full address? I know that by hovering the mouse over, you will get the address, as well as viewing the hyperlink, but I want to change the "howard" to the full address. Any help or direction would be appreciated. Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    199
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: View Hyperlink Address (Excel 97)

    To view the hyperlinks you can use Ctrl+K on the appropriate cell to display the Edit Hyperlink window, and the url is usually highlighted. Then you can copy the url - Ctrl+C, and select Remove Link. The window will disappear and the cell will no longer be a hyperlink. Finally just paste the url from the clipboard using Ctrl+V and "howard" will be replaced with the url.

    Hope this helps.

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Hyperlink Address (Excel 97)

    Peter:

    it works great, thank you very much!

Posting Permissions

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