Enter array formula

Enters or updates an array formula in selected cells, letting you handle advanced calculations that involve multiple ranges or outputs.

Shortcut Windows Mac
Enter array formula Ctrl Shift Enter Ctrl Shift Return

Relevant Excel Shortcuts

Discover related Excel keyboard shortcuts in the formula tools category.

Open Insert Function dialog box
Open Formula builder
Insert function arguments
Display Function Arguments dialog box
Display Formula Builder dialog box
Autosum selected cells

Download Your Complete Excel Shortcuts Cheat Sheet

Get instant access to a comprehensive PDF guide of all Excel keyboard shortcuts available on our website. Perfect for quick reference and offline use for both Mac and Windows users. Click below to download your copy and boost your productivity today!

Free PDF
PDF guide of all Excel shortcuts for Windows and Mac