200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Enter an array formula

Once you have added a function name (I.E. "SUM") to your cell, this shortcut will insert closed brackets ready to be filled with the required information needed to execute. This is used to create array functions which can perform one or more calculations at once. For more information on array functions, see this Microsoft guide: http://bit.ly/1QYqMQP.

Ctrl Shift Enter

Control Shift Enter

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.