Forum Discussion

JackB701's avatar
JackB701
Copper Contributor
Aug 05, 2022
Solved

addition

I created a budget and  for some reason when I revise numbers my total does not add unless I hit the  f2 function and hit enter. How can I change this so I don't have to use the function key to simpl...
excel
  • ScottLamond's avatar
    ScottLamond
    Aug 05, 2022
    In the Formulas tab, click Calculation Options and make sure it's set to Automatic.
ScottLamond's avatar
ScottLamond
Brass Contributor
Aug 05, 2022
In the Formulas tab, click Calculation Options and make sure it's set to Automatic.
  • JackB701's avatar
    JackB701
    Copper Contributor
    Aug 05, 2022
    Thanks !!! I don't know how it got set to manual
    • ScottLamond's avatar
      ScottLamond
      Brass Contributor
      Aug 05, 2022
      You typed <Alt><M> and then typed <X><M>, inadvertently, as one example.

Resources