Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I prevent loosing formula during data entry?
I have a work book that has data containing formulas. while editing the
same , on some cells, it was found that the formula is getting lost during data entry....Can some one help me on this please...... |
#2
|
|||
|
|||
A cell can only contain either data (input) or a formula, not both.
You should normally enter the data where the formula points to, e.g.: if the formula in C1 is: =SUM(A1:B1), then data (i.e. numbers) could be entered into A1 and B1, and C1 will then compute the total .. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Thomas Jacob" <Thomas wrote in message ... I have a work book that has data containing formulas. while editing the same , on some cells, it was found that the formula is getting lost during data entry....Can some one help me on this please...... |
#3
|
|||
|
|||
if the data is being entered in the wrong cell, You should concider
protecting cells except those available for data entry. Being a klutz, I do this even on stuff I do only for myself. "Thomas Jacob" wrote: I have a work book that has data containing formulas. while editing the same , on some cells, it was found that the formula is getting lost during data entry....Can some one help me on this please...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
how do I merge 2 cells in excel without loosing data | Excel Discussion (Misc queries) | |||
Formula presumes cells have data | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |