Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DROP
DROP removes the first or last N rows and/or columns from an array, returning everything else. It is the complement of TAKE. Positive numbers drop from the beginning and negative numbers drop from the end. Available in Excel 365 and Google Sheets as a dynamic array function.
Excel
=DROP(A1:C5,1)Google Sheets
=DROP(A1:C5,1)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A1:C5 is the source array you want to trim.
- 21 tells DROP to remove the first 1 row (typically the header row) from the result.
- 3Use a negative number like -1 to drop the last row instead.
Need a version for your data?
Try: “Remove the header row from my range and return just the data rows”