Here, the ROW function returns an array with 10 items: and each item in this array is displayed in a different cell.

Steps to enter a multi-cell array formula

To enter a multi-cell array formula, follow these steps: Multi-cell array formulas have unique characteristics: To select all the cells in a multi-cell array formula, you can use the keyboard shortcut control + / Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.