Enter array formula: the shortcut in both apps
On Windows it is usually Ctrl+Shift+Enter (2 of 2 apps). The table shows where each app agrees and where it differs.
| App | Mac | Windows | Linux |
|---|---|---|---|
| Google SheetsInsert an array formula | ShiftCmdEnter | CtrlShiftEnter | CtrlShiftEnter |
| ExcelEnter a formula as an array formula | CtrlShiftEnter | CtrlShiftEnter | — |
How the apps compare
- Mac: Cmd+Shift+Enter in Google Sheets; Ctrl+Shift+Enter in Excel.
- Windows: every app here uses CtrlShiftEnter.
- Linux: Ctrl+Shift+Enter in Google Sheets.
Learn it by pressing it: Google Sheets shortcuts practice or Excel shortcuts practice.