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 quot;sum(g7,j7)quot; for example, the following message will
appear: quot; mailto:=sum(g7,j7). click once to follow, click and hold to select
thsi cellquot;. Double clicking will send me to my 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 quot;Hyperlinkquot;. You
should then see a button for quot;Remove Hyperlinkquot;. Your formulas will not be
affected, but they should look normal now.
HTH,
Elkarquot;Fred in Keswickquot; wrote:
gt; Why do some Excel cells display fonts of a different colors. Specificaly,
gt; when I use a sum function, the result appears sometimes in in blue, somtimes
gt; in green and sometimes in purple. When I highlight these cells , if the
gt; formula in the cell is quot;sum(g7,j7)quot; for example, the following message will
gt; appear: quot; mailto:=sum(g7,j7). click once to follow, click and hold to select
gt; thsi cellquot;. Double clicking will send me to my e-mail.
- Mar 09 Fri 2007 20:36
Why do some Excel cells refer to e-mail?
close
全站熱搜
留言列表
發表留言