EXPAND Function
The EXPAND function is a lookup and reference function. It is used to expand a range of data (array) by adding rows and columns.
Please note that this is an array formula. To learn more, please read the Insert array formulas article.
The EXPAND function syntax is:
=EXPAND(array, rows, [columns], [pad_with])
where
array is the range of cells to be expanded,
rows is the number of rows in the returned array. Although this is a required argument, if omitted, rows will not be added and the number of columns must be specified.
[columns] is an optional argument identifying the number of columns in the returned array. If omitted, columns will not be added and the number of rows must be specified.
[pad_with] is the value to fill in the added cells. #N/A is the default value.
To apply the EXPAND function,
- select the cell where you wish to display the result,
-
click the Insert function icon situated at the top toolbar,
or right-click within a selected cell and select the Insert Function option from the menu,
or click the icon situated at the formula bar,
- select the Lookup and Reference function group from the list,
- click the EXPAND function,
- enter the required arguments separating them by comma,
- press the Enter button.
The result will be displayed in the selected cell.
Return to previous page