Shortcut to Calculate a Spreadsheet
You can Calculate a spreadsheet manually by pressing the F9 key.
But doesn’t Excel automatically Calculate a spreadsheet? By default yes, however here’s a couple reasons the F9 key has come in handy in the past:
UDF’s: After modifying code in a User Defined Function and returning to the spreadsheet, you can press F9 to make the Spreadsheet Calculate to see the results of your code changes.
Automatic Calulation is Turned Off: Once in a blue moon you may use Excel with the automatic calculation turned off via the Tools->Options->Calculation menu. Large spreadsheets can sometimes take a few seconds to calculate with each value change. With Calculation turned off you can work for awhile and manually calculate the spreadsheet with F9 when you’re ready.
You will see at the bottom a hint that it is ‘uncalculated’ – don’t know what it says in english, in german it is Berechnen.
Plus if you just want to calculate the actual Sheet, press SHIFT-F9.
And just the current cell: F2 (to edit the cell) and just Enter.
hth
Nicole
It’s basically the same in English, In the status bar it says “Calculate” when you need to manually calculate the sheet. BTW, nice site, I’ll be checking out a podcast or two in a bit.
Shift-F9 was new to me. Thanks for the additional info.