EXPAND Function

The EXPAND function is one of the lookup and reference functions. It is used to expand a range of data (array) by adding rows and columns.

Syntax

EXPAND(array, rows, [columns], [pad_with])

The EXPAND function has the following arguments:

Argument	Description
array	The range of cells to be expanded.
rows	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	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	The value to fill in the added cells. #N/A is the default value.

Notes

Please note that this is an array formula. To learn more, please read the Insert array formulas article.

How to apply the EXPAND function.

Examples

The figure below displays the result returned by the EXPAND function.

Alla pagina precedente