Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change an e-mail address in Excel?
When I make a change in an e-mail address in Excel it shows up visually but
when I click on it, it opens an e-mail with the old e-mail address. Please help. |
#2
|
|||
|
|||
Click on the cell and delete the old address. Then click the insert menu,
hyperlink and in the address bar at the bottom of the window that opens, type the new email address and click ok.(Excel 2002) May vary slightly for other versions of excel. HTH Ken |
#3
|
|||
|
|||
Hi Sheila,
Right-click the hyperlink, Hyperlink | Edit hperlink... opens a hyperlink edit dialog . The dialog can be used to edit the email address and/or the worksheet representation. --- Regards, Norman "Sheila" wrote in message ... When I make a change in an e-mail address in Excel it shows up visually but when I click on it, it opens an e-mail with the old e-mail address. Please help. |
#4
|
|||
|
|||
Ken it doesn't give me the option to insert a hyperlink. I have Windows XP
"Ken Macksey" wrote: Click on the cell and delete the old address. Then click the insert menu, hyperlink and in the address bar at the bottom of the window that opens, type the new email address and click ok.(Excel 2002) May vary slightly for other versions of excel. HTH Ken |
#5
|
|||
|
|||
Hi
I have win xp as well and also excel 97 and excel 2002 and both have hyperlink on the insert menu. Sorry, but I don't know why you don't. Maybe Norman Jones suggestion will work for you. Ken |
#6
|
|||
|
|||
A shortcut to that hyperlink dialog is to select the cell, then hit ctrl-k.
Sheila wrote: When I make a change in an e-mail address in Excel it shows up visually but when I click on it, it opens an e-mail with the old e-mail address. Please help. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How do I change the thickness of a bottom boarder in Excel 2002? | Excel Discussion (Misc queries) | |||
mail merge from excel | Excel Discussion (Misc queries) |