ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Change email addresses (https://www.excelbanter.com/excel-discussion-misc-queries/54498-change-email-addresses.html)

Frank C

Change email addresses
 
I have a column that contains email addresses. Each time I try to change the
contents of a cell it opens word as the email editor for that address How do
I stop this without negating the hyperlink? Also, How do i change the font
for a column?
Thanks
Frank C

Gary''s Student

Change email addresses
 
Select the cell with the arrow keys (not the mouse) and edit in the formula
bar.

To change font for the column, select the column and Format Cells... Font

and make your selections
--
Gary's Student


"Frank C" wrote:

I have a column that contains email addresses. Each time I try to change the
contents of a cell it opens word as the email editor for that address How do
I stop this without negating the hyperlink? Also, How do i change the font
for a column?
Thanks
Frank C


Dave Peterson

Change email addresses
 
I like to sneak up on the cell.

I use the mouse to select a cell close, then I use the arrow keys to get to the
cell I want.

You can also click on the cell--but hold the click a little longer until the
finger changes to a block cross.

Select the column
then apply the format you want
format|cells|font tab


Frank C wrote:

I have a column that contains email addresses. Each time I try to change the
contents of a cell it opens word as the email editor for that address How do
I stop this without negating the hyperlink? Also, How do i change the font
for a column?
Thanks
Frank C


--

Dave Peterson

PCLIVE

Change email addresses
 
One way to keep the link from activating your default mail editor, is to
hold the ctrl key when you click on the cell containing the email address.
Then you can either press F2 to edit the contents or just click on the
forumla bar.

HTH,
Paul

"Frank C" wrote in message
...
I have a column that contains email addresses. Each time I try to change
the
contents of a cell it opens word as the email editor for that address How
do
I stop this without negating the hyperlink? Also, How do i change the font
for a column?
Thanks
Frank C




Frank C

Change email addresses
 
Thanks to all
Those suggestions worked!Frank C

"Frank C" wrote:

I have a column that contains email addresses. Each time I try to change the
contents of a cell it opens word as the email editor for that address How do
I stop this without negating the hyperlink? Also, How do i change the font
for a column?
Thanks
Frank C



All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com