You can get Excel to recalculate formulas and functions in all open workbooks, or just in one worksheet in a workbook.
Press F9 to recalculate formulas in all open Excel workbooks.
Press Shift + F9 to recalculate formulas in the active worksheet.
Now, usually, Excel automatically updates the results of formulas and functions whenever something changes. So you only need these shortcuts if the Calculation Option is set to Manual.
So why would anyone change the calculation option from Automatic to Manual? Well, when working with very large files, the constant updating, whenever changes are made, can be slow. Therefore, people will sometimes switch to Manual mode while working through changes on worksheets that have a lot of data.
The Calculation Option is on the Formulas ribbon (Alt + M, then X).
Calculate Formulas in Excel Spreadsheets
posted in: Shortcut of the Week
0
Leave a Reply