Ctrl Alt F9

  • Thread starter Thread starter Heath
  • Start date Start date
H

Heath

I have a spreadsheet that I would like to be able to
update all of the formulas in at one time. After
researching this I found that the button combination
Ctrl+Alt+ is supposed to do this. The problem is that
when I use this combination nothing happens. I have
checked the Calculations tab under Tools | Options but
this is set to Automatic. Any suggestions would be
greatly appreciated.
 
Hi
if your calculation mode is set to 'Automatic' hitting CTRL+ALT+F9 in
most cases won't change anything. Your formula results are current - no
need to update them.
To see the effect of this shortcut change your calculation mode to
'Manual', enter some formulas and try hitting F9 or CTRL+ALT+F9 again
 
Back
Top