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.
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.
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.
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.

Download 200+ Excel Shortcuts

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