I'm very new at using excel and if someone could help me please how
do I keep a formula in a cell example I've put the formula in the cell
and go back to it to enter some data and need to clear the data I
always seem to clear my formula what do I do????to keep the formula in
the cell Thanks gg--
genevieveg
------------------------------------------------------------------------
genevieveg's Profile: www.excelforum.com/member.php...oamp;userid=30333
View this thread: www.excelforum.com/showthread...hreadid=499991Formulas cant work in the cell they occupy, nor can a formula change the
contents of a cell it occupies. Say in A1 there was the formula:
=B1 C1
then A1 will display the sum of B1 and C1,
If you go back to A1 and enter something else, the formula is gone,
Regards,
Alan.
quot;genevievegquot; gt; wrote
in message ...
gt;
gt; I'm very new at using excel and if someone could help me please how
gt; do I keep a formula in a cell example I've put the formula in the cell
gt; and go back to it to enter some data and need to clear the data I
gt; always seem to clear my formula what do I do????to keep the formula in
gt; the cell Thanks gg
gt;
gt;
gt; --
gt; genevieveg
gt; ------------------------------------------------------------------------
gt; genevieveg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30333
gt; View this thread: www.excelforum.com/showthread...hreadid=499991
gt;
- Dec 18 Thu 2008 20:47
clearing a cell
close
全站熱搜
留言列表
發表留言
留言列表

