Skip to content
ExcelExcel 2024+

DROP function in Excel

Excludes a specified number of rows or columns from the start or end of an array

=DROP(array, rows, [columns])

DROP syntax and parameters

Three arguments, two required.

  • arrayarrayRequired
  • rowsnumberRequired
  • columnsnumberOptional

DROP examples

Formulas you'll actually reuse.

  1. Everything except the header row:

    =DROP(A1:F200, 1)

  2. Drop the header AND the last two columns — negatives count from the end:

    =DROP(A1:F200, 1, -2)

DROP in Google Sheets

No direct equivalent — here's the way around.

Try DROP in the playground

Edit the example — nothing to install.

Preloaded with the DROP formula from Example 1 — change anything and watch it respond.

Loading the editor…

DROP errors

What they mean — and the fixes.

  • #VALUE!

    rows or columns exceeds the array's size — you'd be dropping more than exists.

Related functions

More ways Excel gets this done.