Excel
Word
PowerPoint
Outlook
Google Sheets
Google Docs
Google Slides

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

Popular Functions

Hand-picked function guides that work in both Excel and Google Sheets.

SUMIF Function in Excel & Google Sheets (Syntax + Examples) SUM Function in Excel & Google Sheets (Syntax + Examples + Fixes) FORECAST Function in Excel & Google Sheets FILTER Function in Excel & Google Sheets (Syntax + Examples + Fixes)