What is DROP called in Spanish?

In Spanish Excel it is EXCLUIR. The formula =DROP(A2:B9,-1) is written =EXCLUIR(A2:B9;-1) (or with commas in Mexico).

Why does DROP use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel DROP function

Removes rows or columns from the start or end of a range. In Spanish Excel it is called EXCLUIR.

Syntax

English Excel

=DROP(array, rows, [columns])

Spanish Excel (Mexico)

=EXCLUIR(matriz, filas, [columnas])

Spanish Excel (Spain, Latin America)

=EXCLUIR(matriz; filas; [columnas])

Argument	What it is
array	The range or result.
rows	How many rows to remove; negative removes from the end.
columnsoptional	How many columns to remove.

Example

DROP(range, rows) removes rows from the start (or from the end, with a negative number). It helps when imported data has a total row you do not want to sort.

=DROP(A2:B9,-1)

Common mistake

Excel 365 only. It is the opposite of TAKE: DROP(range,1) removes the headers.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice DROP

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/112

My Excel is inExcel functions in English and Spanish

Remove rows with DROP

DROP(range, rows) removes rows from the start (or from the end, with a negative number). It helps when imported data has a total row you do not want to sort.

Example=DROP(A2:B9,-1)EXCLUIR = DROP ORDENAR = SORT

Step 1/2

In D2, show the table A2:B9 without the total row.

	A	B
1	Branch	Sales
2	Downtown	48,200.00
3	North	35,900.00
4	South	61,750.00
5	East	29,400.00
6	West	52,300.00
7	Airport	44,100.00
8	Mall	38,650.00
9	Total	310,300.00
10

Tip: while typing, click a cell or drag across several to insert their reference. F4 anchors the reference with $.

Frequently asked questions

What is DROP called in Spanish?: In Spanish Excel it is EXCLUIR. The formula =DROP(A2:B9,-1) is written =EXCLUIR(A2:B9;-1) (or with commas in Mexico).
Why does DROP use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common DROP mistake?: Excel 365 only. It is the opposite of TAKE: DROP(range,1) removes the headers.