Excel -how do I edit an entry that's an email address

[Kurt]

Excel has that annoying function that makes all email addresses
clickable (like it or not), but as such, are extremely difficult to
edit. How do I easily select it only to make changes?

 

[michael.broughton1]

Select the cell that the email address is in just by arrowing over to
it if you don't want to accidentally click the email and then go to
Insert- Hyperlink and on the bottom left of the box click "remove link"
and then the email address won't be clickable anymore, thus your
problem solved. This is annoying and in word I think you can make it so
that your email addresses don't automatically become hyperlinks but i
can't find this in excel.

 

[Paul Berkowitz]

To do it all in one fell swoop (Excel 2004):

Open Script Editor (in /Applications/Applescript/).

Paste the following in, compile, and run:

tell application "Microsoft Excel"
delete every hyperlink of active sheet
end tell



--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[PhilD]

Excel has that annoying function that makes all email addresses
clickable (like it or not), but as such, are extremely difficult to
edit. How do I easily select it only to make changes?

If you want the link to remain "clickable", go to a nearby cell, use
the arrows to go the the email address cell, and press command-U to
edit the contents. I am assuming that you have not customised the
keyboard commands.

PhilD

 

[CyberTaz]

You can also Ctrl+Click the cell & choose from the options in the contextual
menu or press ESC to close it - the cell will remain selected.

Another option - Click the currently displayed reference in the Name Box
(left end of the Formula Bar), type the reference of the cell, press Return.

Also, Cmd+G (IIRC) for the Go To dialog (Edit>Go To), specify the cell
reference, Return/OK.

I'll stop now

 

[Kurt]

To do it all in one fell swoop (Excel 2004):

Open Script Editor (in /Applications/Applescript/).

Paste the following in, compile, and run:

tell application "Microsoft Excel"
delete every hyperlink of active sheet
end tell

Tiger with excel 2004.

Gets an Applescript error
"Microsoft Excel got an error: every hyperlink of active sheet doesn't
understand the delete message.

 

[Bob Greenblatt]

Tiger with excel 2004.

Gets an Applescript error
"Microsoft Excel got an error: every hyperlink of active sheet doesn't
understand the delete message.

Kurt,
If you are tying in these addresses instead of copying and pasting, or
importing them otherwise, simply type an apostrophe " ' " before the
address. Excel will not treat it like a hyperlink, and the apostrophe will
not be visible in the cell.

 

[Kurt]

Select the cell that the email address is in just by arrowing over to
it if you don't want to accidentally click the email and then go to
Insert- Hyperlink and on the bottom left of the box click "remove link"
and then the email address won't be clickable anymore, thus your
problem solved. This is annoying and in word I think you can make it so
that your email addresses don't automatically become hyperlinks but i
can't find this in excel.

Thanks, cumbersome, but it works!

 

[Kurt]

Kurt,
If you are tying in these addresses instead of copying and pasting, or
importing them otherwise, simply type an apostrophe " ' " before the
address. Excel will not treat it like a hyperlink, and the apostrophe will
not be visible in the cell.

Used the cumbersome, remove hyperlink feature. Cannot edit a cell,
otherwise.

Any idea about the script error?

Also, once the script is created, where should it live?

 

[Kurt]

You can also Ctrl+Click the cell & choose from the options in the contextual
menu or press ESC to close it - the cell will remain selected.

Another option - Click the currently displayed reference in the Name Box
(left end of the Formula Bar), type the reference of the cell, press Return.

Also, Cmd+G (IIRC) for the Go To dialog (Edit>Go To), specify the cell
reference, Return/OK.

I'll stop now

Why does MS make it so hard?

 

[CyberTaz]

Welllll... default hyperlink activity can be either On or OFF, so any s/w
developer has a 50/50 chance of getting it "right" in the preference of any
given user

You won't believe the number of people who started griping when hyperlinks
in Word were changed to inactive as the default - primary rationale: "It's
too much trouble to Ctrl+Click rather than just Click".

BTW, I saved [what may be] the best for last: Click & Hold for a second on
the cell untill the pointer appears as a White Cross to select the cell,
then edit in the Formula Bar or Cmd+U to edit directly in the cell.

 

[Kurt]

Welllll... default hyperlink activity can be either On or OFF, so any s/w
developer has a 50/50 chance of getting it "right" in the preference of any
given user

You won't believe the number of people who started griping when hyperlinks
in Word were changed to inactive as the default - primary rationale: "It's
too much trouble to Ctrl+Click rather than just Click".

BTW, I saved [what may be] the best for last: Click & Hold for a second on
the cell untill the pointer appears as a White Cross to select the cell,
then edit in the Formula Bar or Cmd+U to edit directly in the cell.

That doesn't work for me. Never changes from the hand.

 

[CyberTaz]

Sorry - On the Mac the pointer *doesn't* change, in PC XL it does. However,
if you click & hold on the cell it does work the same way, just without the
pointer appearance changing. Take a look at the Formula Bar & when you
release the cell will be selected without launching your email client... And
the keystroke to edit in the cell is CONTROL+U, not Cmd+U (Unless you have
Edit Directly in Cell unchecked in Preferences) --- that's what I get for
referring to someone else's post ;-)

Regards |:>)
Bob Jones
[MVP] Office:Mac

Welllll... default hyperlink activity can be either On or OFF, so any s/w
developer has a 50/50 chance of getting it "right" in the preference of any
given user

You won't believe the number of people who started griping when hyperlinks
in Word were changed to inactive as the default - primary rationale: "It's
too much trouble to Ctrl+Click rather than just Click".

BTW, I saved [what may be] the best for last: Click & Hold for a second on
the cell untill the pointer appears as a White Cross to select the cell,
then edit in the Formula Bar or Cmd+U to edit directly in the cell.

That doesn't work for me. Never changes from the hand.

 

[PhilD]

And
the keystroke to edit in the cell is CONTROL+U, not Cmd+U (Unless you have
Edit Directly in Cell unchecked in Preferences) --- that's what I get for
referring to someone else's post ;-)

'Course it is. Command-U underlines. It's so easy to get in a muddle
when chopping and changing between computers, and talking about one
whilst working at another.

Despite putting "Apple" stickers on my work PC, it still doesn't behave
like a Mac.



PhilD

 

[Kurt]

Sorry - On the Mac the pointer *doesn't* change, in PC XL it does. However,
if you click & hold on the cell it does work the same way, just without the
pointer appearance changing. Take a look at the Formula Bar & when you
release the cell will be selected without launching your email client... And
the keystroke to edit in the cell is CONTROL+U, not Cmd+U (Unless you have
Edit Directly in Cell unchecked in Preferences) --- that's what I get for
referring to someone else's post ;-)

Regards |:>)
Bob Jones
[MVP] Office:Mac

Still does nothing. Bar up top still gives me the local url for the
email address. It's the "thing that wouldn't leave."

Welllll... default hyperlink activity can be either On or OFF, so any s/w
developer has a 50/50 chance of getting it "right" in the preference of any
given user

You won't believe the number of people who started griping when hyperlinks
in Word were changed to inactive as the default - primary rationale: "It's
too much trouble to Ctrl+Click rather than just Click".

BTW, I saved [what may be] the best for last: Click & Hold for a second on
the cell untill the pointer appears as a White Cross to select the cell,
then edit in the Formula Bar or Cmd+U to edit directly in the cell.

That doesn't work for me. Never changes from the hand.

--
Regards |:>)
Bob Jones
[MVP] Office:Mac

You can also Ctrl+Click the cell & choose from the options in the
contextual
menu or press ESC to close it - the cell will remain selected.

Another option - Click the currently displayed reference in the Name Box
(left end of the Formula Bar), type the reference of the cell, press
Return.

Also, Cmd+G (IIRC) for the Go To dialog (Edit>Go To), specify the cell
reference, Return/OK.

I'll stop now
--
Regards |:>)
Bob Jones
[MVP] Office:Mac


Kurt wrote:
Excel has that annoying function that makes all email addresses
clickable (like it or not), but as such, are extremely difficult to
edit. How do I easily select it only to make changes?



If you want the link to remain "clickable", go to a nearby cell, use
the arrows to go the the email address cell, and press command-U to
edit the contents. I am assuming that you have not customised the
keyboard commands.

PhilD

--
<><


Why does MS make it so hard?

 

[Kurt]

There's another option:
1. select the whole row/column wher you have email address entry
2. do apple+c
3 and paste it as special (edit>paste>special>VALUES)
This will remove the hyperlink as well.

????
That crashes Excel for me. Never crashed Excel any other way before.

 

[Kurt]

Or you can use this VBA macro

Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

This finally worked, thanks!