⚡Formulas
How to insert an array formula in Google Sheets
Enter an array formula that can return results across multiple cells.
Ctrl + Shift + Enter
📋 Step-by-Step Guide
- 1.Open Google Sheets in your browser.
- 2.Select the cell(s) you want to work with.
- 3.Press Ctrl + Shift + Enter to insert an array formula.
🎯 Shortcut Keys by Platform
| Platform | Shortcut |
|---|---|
| 💻 PC / Windows | Ctrl + Shift + Enter |
| 🍎 Mac | ⌘ + Shift + Enter |
| 💻 Chrome OS | Ctrl + Shift + Enter |
💡 Pro Tips
- You can combine this shortcut with the other Common Actions shortcuts to speed up your workflow.
- If you forget this shortcut, press Ctrl + / (or ⌘ + / on Mac) to see all available keyboard shortcuts in Google Sheets.
❓Frequently Asked Questions
📚 Explore All Google Sheets Shortcuts
Discover 111 keyboard shortcuts to boost your productivity
View All Shortcuts ➜Related Shortcuts
⚡ Accelerator Keys
See shortcuts, hints & docs right inside Google Sheets.
Download Accelerator Keys Now