Enter a formula as an array formula
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
Ctrl + Shift + Enter
⌘ + Shift + Enter
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Shift + Enter
Instructions
1. Type your formula
2. Press Ctrl + Shift + Enter
3. Excel wraps the formula in curly braces {} indicating an array formula
2. Press Ctrl + Shift + Enter
3. Excel wraps the formula in curly braces {} indicating an array formula
Keyboard Shortcut
⌘ + Shift + Enter
Instructions
1. Enter formula
2. Press Command + Shift + Enter
3. Creates an array formula automatically
2. Press Command + Shift + Enter
3. Creates an array formula automatically
💡 Pro Tip: Use for calculations that return multiple values in a single formula.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U