Array Formula Entry

Enter a formula as an array formula applying it across a selected range.


Keyboard shortcut by app

App Windows Mac
Microsoft 365
Excel
Ctrl+Shift+Enter
Ctrl+Shift+Enter
Word Not available Not available
PowerPoint Not available Not available
Outlook Not available Not available
Teams Not available Not available
Google Workspace
Google Sheets
Ctrl+Shift+Enter
Ctrl+Shift+EnterCtrl+Shift+Enter
Google Docs Not available Not available
Google Slides Not available Not available

More in Formulas
Accept Autocomplete Suggestion AutoSum Calculate Active Sheet Only Calculate All Open Workbooks Copy Formula Down Copy Formula Right Evaluate Part of a Formula Expand or Collapse Formula Bar Insert Function Dialog Name a Cell or Range Open Function Arguments Dialog Remove All Tracer Arrows Start a Formula Toggle Absolute and Relative Reference Toggle Show Formulas Trace Dependents Trace Precedents