Ask Experts Questions for FREE Help !
Ask
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #1

    Oct 8, 2010, 01:17 PM
    Excel 2007 mulitple hyperlinks
    Yeah OK so my brain is mush.

    I have a sheet with a number of incremented links pointing at various pages on a site.
    Now I want to turn these into active hyperlinks, WITHOUT doing each individually as I have a ton to do.

    So looks a bit like this

    http://www.site.com/page1.htm
    http://www.site.com/page2.htm
    http://www.site.com/page3.htm
    http://www.site.com/page4.htm
    http://www.site.com/page5.htm

    I would like to be able to increment the hyperlink in the same (or similar) way as I drag down to do the numbering.

    Any ideas?

    Yes I have tried setting the link on the first on and then dragging the series down, but the link itself doesn't change.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Oct 9, 2010, 04:47 PM

    If those text strings are in column A starting at A1, put this formula in B1 and copy down:

    =HYPERLINK(A1, A1)

    Now the links in column B are active and dynamic.
    Curlyben's Avatar
    Curlyben Posts: 18,514, Reputation: 1860
    BossMan
    		  
    #3

    Oct 9, 2010, 11:12 PM
    Outstanding cheers JB.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Oct 11, 2010, 12:23 PM

    Heh... we are a village!
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Why my hyperlinks in Excel do not open pdf & pic. Files ? [ 1 Answers ]

Dear Sirs, In MS-Excel I make some hyperlinks, for example in an Excel sheet I write "2007" and then by right click I select "hyperlink..." and make a hyperlink to open a file on my computer. When I click on my hyperlinked cell or word in mentioned Excel sheet, If hyperlinked file is PDF or...

Excel and Hyperlinks to Open Pdf files [ 1 Answers ]

I created an excel spreadsheet with hyperlinks to open pdfs in a folder. I am getting "cannot open file" error.

Excel hyperlinks don't open in PDF [ 6 Answers ]

I have created some hyperlinks in an Excel preedsheet, when I convert the worksheet to a PDF, the hyperlinks are not active. What do I need to do to activate them in the PDF or what is it that I need to do in Excel before converting to a PDF? What am I doing wrong?

Modify Hyperlinks in Excel 2003 [ 1 Answers ]

Hi, I upgraded to excel 2003 from excel 2000. The 2003 version modified my hyperlinks putting %20 where there had blank spaces. I found why and took care of that problem, but, it didn't change what had been change. So I need to replace the %20 with blank spaces, and since I have thousands to do I...

View more questions Search