1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Resolved creating a hyperlink in excel 2007

Discussion in 'Other PC Software' started by cozzielex, 2010/01/03.

  1. 2010/01/03
    cozzielex

    cozzielex Inactive Thread Starter

    Joined:
    2009/03/30
    Messages:
    291
    Likes Received:
    0
    Q2 in my building my library inventory.
    Where I insert the name of a book title (e.g. Armageddon), I want to turn the title into a web link i.e. for it to turn blue and lead me directly to a specific web page. Ive been fiddling about with the hyperlink facility in excel 2007 and I cant understand how it works.
    Again, can someone please offer some advice
     
  2. 2010/01/03
    sp3851

    sp3851 Well-Known Member

    Joined:
    2009/11/08
    Messages:
    280
    Likes Received:
    4

  3. to hide this advert.

  4. 2010/01/03
    cozzielex

    cozzielex Inactive Thread Starter

    Joined:
    2009/03/30
    Messages:
    291
    Likes Received:
    0
    Thanks for that, Ive been to that site and I just cant follow it. I'd be grateful if someone could very simply explain the procedure for me>
    Thanks
     
  5. 2010/01/03
    sp3851

    sp3851 Well-Known Member

    Joined:
    2009/11/08
    Messages:
    280
    Likes Received:
    4
    You can also type text into a cell. Then select that cell. On the top menu select Insert -> Hyperlink. This will open a new window. You will see a Browse the Web Button.
    Click on it. IE will open. Put in the web address you want to link to the text and pull up the site. Close IE and look at the Address in the Box. Press Ok and the Hyperlink is created.
     
  6. 2010/01/03
    cozzielex

    cozzielex Inactive Thread Starter

    Joined:
    2009/03/30
    Messages:
    291
    Likes Received:
    0
    thanks, Ive tried that button but I get an error message saying 'an error occurred while browsing files'. Thats obviously what i need to do, but can you understand this error message?
    Problem solved sp, I was using firefox as my default browser so the web button in excel wouldnt work. Im up and running now, thanks for your help
     
    Last edited: 2010/01/03

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.