clearing a cell
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: http://www.excelforum.com/member.php...o&userid=30333 View this thread: http://www.excelforum.com/showthread...hreadid=499991 |
clearing a cell
Formulas 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. "genevieveg" wrote in message ... 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: http://www.excelforum.com/member.php...o&userid=30333 View this thread: http://www.excelforum.com/showthread...hreadid=499991 |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com