Active5 months ago
Excel Keyboard Shortcut For Manual Calculation Set up Microsoft Excel 2010 formulas with automatic calculation so that This occurs because the settings for formulas in the workbook have been set to manually calculate. How to Create a Keyboard Shortcut on the iPhone 5 in iOS 7. Keyboard shortcuts primary user hands typing. This shortcut will force calculation in all worksheets in all open workbooks even when cells have not been changed. We aren't aware of a keyboard shortcut to do this on the Mac.
This is driving me a little bit crazy. In my old PC days I used to press either F5 or F9 (I can't remember) to have Excel
recalculate
.What is the Mac equivalent?
PS: Perhaps this is not the place to ask. If so, please redirect me. :)
Thomas Ayoub
1,50844 gold badges1313 silver badges3636 bronze badges
Keep these mindKeep these mind48566 gold badges1313 silver badges2727 bronze badges
3 Answers
AFAIK it's F9 on Windows .
So did you try the keystrokes Fn+F9 ?
IconDaemon12.9k66 gold badges2929 silver badges4343 bronze badges
Matthieu RieglerMatthieu Riegler16.8k77 gold badges4646 silver badges9191 bronze badges
To recalc in Mac:
Command + =
You can try also changing Excel preferences:Command ,Calculation'Manually' radio button
user125450user125450
fn + f9 works if you disable mission control shortcut (it is defined as F9 by default)
Mac Excel Manual Calculation Shortcut Download
Manuel FigueiralManuel Figueiral
You must log in to answer this question.
Manual Calculation Excel 2010
Not the answer you're looking for? Browse other questions tagged microsoft .
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. Is there a way if I hit F9 to stop Excel in the middle of a calculation because I remembered that I didn't correct a number that needed to be corrected for the calculation? Not sure if its possible, but I thought I'd ask.
Thanks.