Home › Functions › Lookup & Reference › DROP
fx
DROP
Lookup & Reference  ·  Since: Microsoft 365  ·  9 languages

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 an Excel report to return only the data.

🌐 Translations

English DROP
Deutsch WEGLASSEN
Français DROP
Español DROP
Italiano DROP
Português DROP
Nederlands WEGLATEN
Polski DROP
Русский СБРОСИТЬ

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

DROP(array,rows,[columns])

Arguments

array (required)
rows (required)
columns (optional)

▶ Examples

=DROP(A2:C4,2)
=DROP(A2:C4,,2)
=DROP(A2:C4,-2)

Related functions

Copied to clipboard