Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred in Keswick
 
Posts: n/a
Default Why do some Excel cells refer to e-mail?

Why do some Excel cells display fonts of a different colors. Specificaly,
when I use a sum function, the result appears sometimes in in blue, somtimes
in green and sometimes in purple. When I highlight these cells , if the
formula in the cell is "sum(g7,j7)" for example, the following message will
appear: " mailto:=sum(g7,j7). click once to follow, click and hold to select
thsi cell". Double clicking will send me to my e-mail.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default Why do some Excel cells refer to e-mail?

The cells have probably been set up as Hyperlinks. To remove them, select
the cell (click and hold), then right-click and select "Hyperlink". You
should then see a button for "Remove Hyperlink". Your formulas will not be
affected, but they should look normal now.

HTH,
Elkar


"Fred in Keswick" wrote:

Why do some Excel cells display fonts of a different colors. Specificaly,
when I use a sum function, the result appears sometimes in in blue, somtimes
in green and sometimes in purple. When I highlight these cells , if the
formula in the cell is "sum(g7,j7)" for example, the following message will
appear: " mailto:=sum(g7,j7). click once to follow, click and hold to select
thsi cell". Double clicking will send me to my e-mail.

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
Maintain proper links when Excel cells are moved Excelnovice Excel Discussion (Misc queries) 0 February 19th 06 06:17 PM
abdualmohsn almedrahe abdualmohsn ahmad Excel Discussion (Misc queries) 1 November 19th 05 06:32 PM
copy & paste spreadsheet cells from excel to outlook to excel mismarple Excel Discussion (Misc queries) 1 September 20th 05 11:16 PM
Cells in Excel will not stop highlighting Boe Excel Discussion (Misc queries) 3 June 14th 05 03:53 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


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

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"