# How To Use Excel DROP Function?

Excel DROP Function: We all know that Microsoft Excel has lots of features for performing mathematical calculations. We can use any of them as per our preferences. On that note, the DROP function is one among them and it helps to remove a specified number of rows and columns from the range of input data set.

Today, we will let you understand the steps involved to use Excel DROP Function in the worksheet using its syntax, and a few practical examples. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Definition of DROP Function

• It is one of the built-in functions in Microsoft Excel.
• This function helps to remove a specified number of rows and columns from the input range on your worksheet.
• It can drop the rows and columns from the start or end of the given array.

## Syntax

• Here, you will see the syntax of the DROP function.
• To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
• Once you enter the formula, click on the button to get the result.

=DROP (array, [rows], [col])

Argument Explanation:

• array – The input array or range.
• rows – It is an optional one. The number of rows to drop.
• col – [optional] Number of columns to drop.

## Examples

Let’s look at some practical examples of the DROP Function and explore how to use it in Microsoft Excel.

• Initially, you have to open your Excel workbook on your PC and launch the worksheet with data.
• example, we have entered the array in the range B3:D6 and we will remove the rows at the end of the array using the DROP function.
• Then, you have to enter the formula in the cell as shown below to get the result. For removing rows at the end of the array, we need to specify the rows using the minus symbol. For example, we specified the row’s argument as -2.
• After entering the formula, you need to click the button to get the output.
• Let’s see another example to make it clear for you. Now we will drop the first two columns from the range. For that, we have to use the following formula.

=DROP(array,,2)

• After entering the formula, you need to click the button to get the output.