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
A2, as per user301746's answer, and then using Paste Special to copy-and-paste first the formatting, and then the value over
A1. 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.