Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Frank C
 
Posts: n/a
Default 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
  #2   Report Post  
Gary''s Student
 
Posts: n/a
Default 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

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
  #4   Report Post  
PCLIVE
 
Posts: n/a
Default 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



  #5   Report Post  
Frank C
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing email addresses Knowna Excel Discussion (Misc queries) 1 May 26th 05 05:12 AM
email addresses in cells tonyayres Excel Discussion (Misc queries) 2 April 27th 05 01:16 PM
Random hyperlinks everywhere FNORD Links and Linking in Excel 8 February 3rd 05 05:33 PM
Using CONCATENATE function to create email addresses from a list Almamba Excel Worksheet Functions 2 January 23rd 05 09:10 PM
Convert entire columns of text email addresses to hyperlinks TSA Excel Worksheet Functions 2 January 20th 05 04:31 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"