# EXPAND

## Content

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

>type=note
> **Note**: EXPAND is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

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

## Arguments

The function provides the following arguments.

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] The array to expand. |
| *rows* | [Required] 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 be 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.

## Examples

![expand-snapshot.png](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/expand-snapshot.d07fd2.png)