ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Why do some Excel cells refer to e-mail? (https://www.excelbanter.com/excel-worksheet-functions/74482-why-do-some-excel-cells-refer-e-mail.html)

Fred in Keswick

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.

Elkar

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.



All times are GMT +1. The time now is 02:01 PM.

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