Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
#5
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing email addresses | Excel Discussion (Misc queries) | |||
email addresses in cells | Excel Discussion (Misc queries) | |||
Random hyperlinks everywhere | Links and Linking in Excel | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions |