I have an Excel spreadsheet with around 900 cells each of which contains a URL, which I've pasted in from another program.
If I select a cell and hit F2, then hit Enter, Excel adds a hyperlink to the cell, whose Address is the cell contents.
Is there a mechanism in Excel 2010 to repeat this step for my many hundreds of cells, without having to do the F2 Enter step manually?
(I know that I could automate it in AutoHotKey, but I'm hoping not to need to do that)
Clarification: I specifically want to end up with hyperlinks added to my existing cells, rather than creating a second column which contains hyperlinks.
Things I tried:
- Creating a temporary extra column, with
=Hyperlink(A1)
inA2
, as per user301746's answer, and then using Paste Special to copy-and-paste first the formatting, and then the value overA1
. This appeared to work, in that the cells in A1 etc were shown in blue and underlined, so they looked like hyperlinks, but actually there weren't linked - it had only copied the hyperlink display style.