DROP in WPS on Windows is a built-in spreadsheet function for excluding a specified number of rows or columns from the start or end of an array; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
DROP is a built-in function in WPS Spreadsheet for handling array results, trimming report ranges, and removing unneeded rows or columns from the beginning or end of returned data. You can insert DROP from the Insert Function dialog box, or type =DROP(...) directly in a cell or in the formula bar.
Core tasks include:
- Insert DROP from the Insert Function dialog box.
- Type
=DROP(...)directly in a cell for faster formula entry. - Review syntax and parameter details before confirming the formula.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory network connection is required for local formula entry; internet access is needed for online help or downloads |
| Other | WPS Office must be installed, and you need to be able to open and edit WPS Spreadsheet files |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open a spreadsheet file, and confirm that the Formulas tab and formula bar are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports using DROP in WPS Spreadsheet through Insert Function or direct formula entry with =DROP(...), and lets you review parameter details while entering the function. | Excel provides the DROP function to exclude a specified number of rows or columns from the start or end of an array. | Google Sheets provides a broad function list and array-related functions, but the official function list does not show a DROP function entry. | Notion formulas support properties, operators, and functions for database calculations rather than spreadsheet-style array trimming functions. | Adobe Acrobat provides JavaScript APIs for PDF automation and document scripting rather than spreadsheet DROP functions. |
| WPS Advantages | Advantage: supports both direct formula entry and an Insert Function workflow in WPS Spreadsheet for everyday formula input and review. | Compared with WPS: Excel documents DROP directly as an array function for removing rows or columns from an array; both products target spreadsheet formula workflows. | Compared with WPS: Google Sheets documents many array functions, but its official function list does not present DROP as a listed function. | Compared with WPS: Notion formulas are designed for database property logic, not cell-based spreadsheet array trimming. | Compared with WPS: Adobe focuses on PDF scripting and automation instead of spreadsheet formula entry. |
| Official Source | — | DROP function | Google Sheets function list | Formula syntax and functions | Acrobat JavaScript API Reference |
Overall Conclusion
If your main task is entering and checking the DROP function in a Windows spreadsheet workflow, WPS provides both direct formula entry and an Insert Function path in one interface. Other products also provide formulas or scripting features, but their official focus and usage model are different.
Use Cases
| No. | Scenario | Suitable for | Main issue | Solution |
|---|---|---|---|---|
| 1 | Remove the first rows from an array result | Data organizers | Returned results include headers or records that should not stay in the final output | Use DROP to exclude a specified number of rows from the beginning of the array |
| 2 | Remove trailing columns from an array result | Report editors | The result includes columns that do not need to be displayed | Use DROP to exclude columns from the end of the array |
| 3 | Check parameters before entering a new function | Spreadsheet beginners | The syntax and parameter order may be unclear | Use Insert Function and the parameter description to confirm the formula |
| 4 | Enter formulas faster in daily work | General office users | Formula entry needs to be completed more quickly | Type =DROP(...) directly in a cell or in the formula bar |
| 5 | Troubleshoot unexpected formula results | Users reviewing formulas | It can be hard to identify why the result is different from expectations | Review the syntax first, then check parameters and referenced ranges |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic spreadsheet function entry | ✅ | ✅ |
| Basic PDF features | ✅ | ✅ |
| Cloud storage | 1 GB | 20 GB |
| Template resources | Limited downloads | More advanced templates and related benefits |
| Some advanced tools | Partially limited | More advanced tools are available |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Daily use of DROP and other basic spreadsheet functions | Free version | It already supports common spreadsheet formula entry and editing |
| More cloud storage, templates, and advanced tools | WPS Premium | Better suited to longer-term office work and broader feature needs |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page