Excel Shortcut: Enter Array Formula

About This Shortcut

Enter Array Formula – This shortcut is used to enter an array formula into a cell, which allows you to perform calculations on multiple values at once.

Keybord Shortcut key

• Window: Ctrl + Shift + Enter
• Mac: Ctrl + Shift + Retrun

Example