How to Use the DROP Function in WPS on Windows

Use the DROP function in 3 how-to topics on Windows in WPS Spreadsheet; all 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Insert DROP from the Insert Function dialog box

Entry: Formulas tab → Insert Function, or the fx button in the formula bar

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
3. Search for DROP in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• Interface result: the target cell contains a DROP formula.
• You can continue: you can edit parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

• When searching for the function name, you can type DROP in uppercase or lowercase.
• Before entering parameters, confirm the referenced range and the number of rows or columns to exclude.

2. Type the DROP formula directly in a cell

Entry: target cell or formula bar

1. Select the cell where you want to enter the formula.
2. Type =DROP(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to apply it elsewhere, copy the formula to adjacent cells.

Success Criteria

• Interface result: the cell shows the calculated result, and the formula bar keeps the DROP formula.
• You can continue: you can select the cell again to edit parameters or copy the formula.

Tips While Using

• Check parentheses, commas, and parameter order before confirming the formula.
• If the result is not what you expect, check the referenced range and parameter values first.

3. Review DROP syntax and parameter details

Entry: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter DROP in the search box.
3. Select the function to review its syntax and parameter details.
4. If you need more information, open the related help entry for a fuller explanation.

Success Criteria

• Interface result: you can see the DROP function name, syntax structure, and parameter details.
• You can continue: you can return to the spreadsheet and keep entering or editing the formula.

Tips While Using

• Focus on the meaning and order of each parameter while reviewing the description.
• Checking the syntax before entry can reduce formula errors.