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.