In Excel 2010, I have a range of cells into which I have copied and
pasted URLs. They all pasted as text and I want them to be active
hyperlinks.

I can activate them one at a time by simply positioning the cursor at
the end of the URL and pressing Enter but I want to activate them all
at once.

I tried:

- Select the range of cells
- Right click
- Click Hyperlink
- Select "Link to: Existing File or Web Page"
- Select "Look In: Browse the Web"

That simply opens my browser.

How can I activate the whole range at once?


Dick Evans