- Mac Excel Manual Calculation Shortcuts
- Mac Excel Manual Calculation Shortcut Key
- Excel Shortcut To Stop Calculation
Does anyone know of a way to stop excel from calculating when it is in the middle of a calculation? I have the file set to manual calculation, which is exactly what I want and I hit F9 to have it calculate. There are hundreds or thousands of formulas in this file so as you can imagine it takes a few minutes sometimes to calculate.
In VBA this can be easily done using the range.calculate command. Once somebody showed me how to do it in Excel with a keyboard shortcut but I do not remember it any more.I have been searching the internet Unsuccessfully to find the shortcut.
Does anybody know the keyboard shortcut to calculate a pre-selected range in Excel?
George
Mac Excel Manual Calculation Shortcuts
Lance Roberts
1 Answer
You should specify your version. In Excel 2003 the closest you can come is to calculate your active sheet using shift+F9 (Just F9 will calculate the whole book).
You can create a macro though that activates Range.Calculate and give that macro a hotkey. You can place that macro in your personal workbook so that it will work no matter what workbooks you have open.