[]
DEMOS BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

EXPAND

This function expands or pads an array to the specified row and column dimensions.

Syntax

=Expand(array, rows, [columns], [pad_with])

Arguments

The function provides the following arguments:

Argument

Description

array

The array to expand

rows

The number of rows in the expanded array. If missing, rows will not be expanded.

columns

[Optional]The number of columns in the expanded array. If missing, columns will not expanded.

pad_with

[Optional] The value with which to pad. The default is #N/A.

Remarks

  • If rows aren't provided or are empty, the default value is the number of rows in the array argument.

  • If columns aren't provided or are empty, the default value is the number of columns in the array argument.

Data Types

The function returns an array,the type of each value in the array depends on the parameter.

Examples


Version Available

This function is available in product version 16.0 or later.

!type=note

Note: The EXPAND function is only available in Beta Insiders builds of Excel for Office 365 currently. Hence, without the Beta Insiders build you cannot import/export the XLSX using this function from/to Excel.