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

Tip: How to generate random values
In this video, we'll look at a few ways to generate random values with the RANDBETWEEN function. You can use this approach to generate random numbers, random prices, random dates, and even random text values. This is a great way to create dummy data to test formulas and worksheets.
Love your tutorials, they've been awesome in helping me learn all that Excel can do.
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course