Exceljet

Quick, clean, and to the point

Enter array formula

Windows shortcut 
CtrlShiftEnter
Mac shortcut 
Return

This shortcut will enter an array formula. When you use this shortcut to enter an array formula, you will see that curly braces surround the formula like so {=formula}.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll walk through each of the error codes that Excel displays when there's something wrong with a formula. We'll also look at some simple ways to resolve the errors.
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function, including random dates, random prices, and random workdays.
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.
In this lesson, we cover shortcuts you can use when working with Excel's functions.