shift M will change to manual calc
goto formulas on the ribbion
then look at calculations options
you will see manual - with a M underlined
then use Shift and M
and it will change to tick manual
then use Shift A
to go back to automatic