I can't seem to find where the Advanced Options are in Excel 2011 on Mac. They used to be under the 'File' or 'Excel' menus but are not there anymore. Specifically, I want to change it so that when I click 'Enter,' the cursor doesn't jump down to the next cell, which would be Editing Options.
- How To Enable Manual Iteration On Excel Mac 2011 Formulas
- How To Enable Manual Iteration On Excel Mac 2011 Delete Hidden Rows
- How To Enable Manual Iteration On Excel Mac 2011 Freeze Top Row
Active5 months ago
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 Ayoub1,50844 gold badges1313 silver badges3636 bronze badges
Keep these mindHow To Enable Manual Iteration On Excel Mac 2011 Formulas
Keep these mind
48566 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
How To Enable Manual Iteration On Excel Mac 2011 Delete Hidden Rows
fn + f9 works if you disable mission control shortcut (it is defined as F9 by default)
Manuel FigueiralManuel Figueiral