How do I make a formula automatically detect changes in values

L

LMoore

How do I make formulas (such as summations) automatically detect when I can a
value in one or more of the cell that are included in the formula without
double clicking cell everytime I make a change?
 
J

John

Check tools>options>calculation tab and make sure it is set to automatic
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
Top