# EXPAND

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content

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

![](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/images/expand-new.png)

## 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.