# DROP

## Content

The function excludes a specified number of rows or columns from the start or end of an array. You might find this function useful to remove headers and footers in a worksheet report to return only the data.

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

## Syntax

`DROP(array, rows, [columns])`

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] Refers to the array from which to drop rows or columns. |
| *rows* | [Required] Refers to the number of rows to drop. A negative value drops from the end of the array. |
| *columns* | [Optional] Refers to the number of columns to exclude. A negative value drops from the end of the array. |

## Remarks

The function returns a #CALC! error to indicate an empty array when either of the row or column is 0.

## Examples

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