Thread
:
Activating hyperlinks
View Single Post
#
4
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 30
Activating hyperlinks
On Tue, 17 Jun 2014 14:40:54 -0400,
wrote:
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?
For future reference:
- Select the target cells.
- Home Styles Cell Styles Hyperlink
Easy peasy.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]