Quick, clean, and to the point

Enter array formula

Windows shortcut 
Mac shortcut 

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.
Dynamic Arrays are the biggest change to the Excel formula engine in years. In this video, I'll explain the basic idea of dynamic array formulas.
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 working with Excel's functions.
In this lesson, we cover shortcuts you can use when building, editing, or entering formulas.
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.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.