close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()