Tip #3186 - Editing an Excel Hyperlink
Printer Friendly Version | E-Mail This Tip
Editing
an Excel Hyperlink
Do you have hyperlinks
in your MS Excel worksheets?
Ever try to click
on it for editing purposes? What happens?
Yep, that's right.
The link is activated and you're accidentally on your way to a Web site
or find that a new e-mail has opened. Either way, it's not what you wanted.
So, how exactly do
we edit the hyperlinks without activating them?
I suppose we could
choose to remove the hyperlink, edit the text and then turn it back into
a hyperlink, but nah, that's way too much work!
While I'm sure there's
a lot of ways to accomplish this task, there's a few I can think of that
aren't too troublesome.
One way that comes
to mind is to select the cell using the keyboard. If you maneuver the
cell selection with the page up/down and arrow keys, you'll be able to
select the cell without activating the link. Then use the F2 key to put
the cursor into the cell for editing the text.
But, what if you're
a person who primarily navigates with the mouse? The moment you click
that link, you're toast. Or maybe not.
Next time, click
and hold the mouse button down on the cell with the link. After
a couple of seconds, you'll notice the cursor change into a plus sign
and then you're free to release the mouse button. You'll find that the
cell has been selected without activating the link. Then use the F2 key
or the Formula bar to edit the text.
That's all there is
to it. Click and hold is your key to link text editing!
~ April
Want To Comment On This Tip? Click Here! We'd love to hear from you :-)
Like These Tips? Get 'Em Free In Your E-mail
