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 .
Active5 months ago
What is the Mac equivalent?
May 01, 2015 Make Formulas Automatically Calculate in Excel 2010. Step 1: Open your file in Microsoft Excel 2010. Step 2: Click the Formulas tab at the top of the window. Step 3: Click the Calculation Options button at the right of of the navigational ribbon, then click the Automatic option. After selecting the Automatic option.
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 mind
48566 gold badges1313 silver badges2727 bronze badges
3 Answers
AFAIK it's F9 on Windows .
Manual Calculations In Excel Mac Download
So did you try the keystrokes Fn+F9 ?
IconDaemon
12.9k66 gold badges2929 silver badges4343 bronze badges
Matthieu Riegler
Excel Manual Calculation Mode
16.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)
Manuel FigueiralManuel Figueiral
You must log in to answer this question.Not the answer you're looking for? Browse other questions tagged microsoft .
Although it’s true that you can gain a better knowledge of any application if you visit its preferences and try to figure them out, it’s almost essential for Excel for Mac 2011. Choose Excel→Preferences from the menu bar to display the Preferences dialog. When you have an inkling or thought about a setting you want to change, just type into the Search field.
Here are some selected settings:
If you turn off Excel’s automatic calculation capability, you need to turn it back on again, or Excel’s formulas won’t calculate. This is especially important if you turn off automatic calculation using a macro. Be certain your code turns the Automatically option back on under all circumstances.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |