![]() |
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 |
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 |
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 |
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 |
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