Skip to content

↑↓ moveEnter openEsc close

Enter a formula as an array formula in Excel

Excel Microsoft 365 · 119 shortcuts · checked Nov 2026 · Source: Microsoft docs

In Microsoft Excel, press Ctrl+Shift+Enter on Mac, Windows.

What else uses Ctrl+Shift+Enter?

More Excel shortcuts: enter data and formulas

ActionMacWindows
Edit the active cell and put the insertion point at the end of its contentsCtrlUorF2F2
Start a new line in the same cellCtrlOptionEnterorOptionCmdEnterAltEnter
Fill the selected cell range with the current entryCtrlEnterCtrlEnter
Complete a cell entry and select the cell aboveShiftEnterShiftEnter
Cancel an entry in the cell or formula barEscEsc
Insert or edit a noteShiftF2ShiftF2
Enter the current dateCtrl;Ctrl;
Enter the current timeCmd;CtrlShift;
Switch between displaying cell values and displaying formulasCtrl`Ctrl`
Copy the formula from the cell above into the active cell or formula barCtrl'Ctrl'

All 24 in enter data and formulas · All 119 Excel shortcuts