DROP in WPS on Windows: Introduction

DROP in WPS on Windows is an array function for removing specified rows or columns from the start or end of an array; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	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

The DROP function in WPS Spreadsheet on Windows helps you remove specified rows or columns from the beginning or end of an array and keep the remaining result area for calculation. When you type =DROP(, the formula bar shows syntax tips, parameter guidance, and examples so you can complete the formula more efficiently.

Core capabilities include:

Enter the DROP function directly in a cell or in the formula bar.
Fill in parameters with syntax guidance.
Use the function with cross-sheet references and nested calculations.
Get updated results when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; downloading, installation, and account-related actions require internet access
Other	An editable spreadsheet file and permission to enter formulas in the worksheet

Source: System Requirements for WPS Office

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office, open Spreadsheet, and type `=DROP(` in a cell to check whether syntax guidance appears

Source: WPS Office Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports entering `=DROP(` in WPS Spreadsheet, viewing syntax guidance, filling in parameters, and combining the function with cross-sheet references and nested calculations for array processing.	Excel provides the DROP function to exclude a specified number of rows or columns from the start or end of an array.	The official Google Sheets function list shows supported functions, and no native DROP entry equivalent to Excel DROP is shown there.	Notion formulas support database properties and functions, but they are not a cell-based spreadsheet function environment.	Acrobat Desktop Help focuses on PDF creation, editing, conversion, and forms rather than spreadsheet array functions.
WPS Advantages	Advantage: typing the function directly shows syntax guidance in the spreadsheet workflow. Distinct: the source feature also supports cross-sheet references, nested calculations, and live result updates.	Compared with WPS: Excel has official DROP function documentation, but this page does not describe the same input-with-guidance workflow.	Compared with WPS: the official Sheets function list does not show a native DROP equivalent, so similar results may require other function combinations.	Compared with WPS: Notion is better aligned with database property formulas than traditional spreadsheet cell formulas written as DROP.	Compared with WPS: Adobe Acrobat is centered on PDF and form workflows rather than spreadsheet function scenarios.
Official Source	—	Excel DROP function	Google Sheets function list	Notion formula syntax	Acrobat Desktop Help

Overall Conclusion
WPS fits direct spreadsheet formula entry well, especially when you want syntax guidance while typing. For a closely matched spreadsheet function reference, Microsoft Excel is the nearest alternative, while Google Sheets, Notion, and Adobe are less aligned with this specific DROP function scenario.

Use Cases

No.	Scenario	Suitable for	Main challenge	How DROP helps
1	Calculating a data range after removing headers	Data organizers	Header rows make follow-up formulas harder to apply directly	Use DROP to remove the first rows and keep only the data area
2	Removing summary rows at the end	Finance and operations users	Totals or notes at the bottom affect later analysis	Use DROP to exclude ending rows and keep the main data body
3	Building nested array formulas	Advanced spreadsheet users	One function alone may not finish the full array trimming task	Use DROP inside nested calculations to adjust row and column ranges
4	Organizing results across worksheets	Multi-sheet collaborators	Data is spread across sheets and repeated cleanup takes time	Combine cross-sheet references with DROP to return the target result
5	Recalculating after source data changes	Report maintainers	Result ranges need repeated adjustment after data updates	Let the formula update results automatically when data changes

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Use the DROP function for basic calculations	✅	✅
Syntax guidance and parameter assistance	✅	✅
More PDF, AI, and advanced tools	Limited in some areas	Broader access
Cloud storage and multi-user sharing benefits	Basic allocation	Higher allocation or more benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily array processing with the DROP function in Spreadsheet	Free	The feature content shows no membership restriction for this function
Broader office work with more PDF, AI, or extended benefits	WPS Premium	Suitable if you need more advanced office capabilities beyond this function

Source: WPS Office pricing page

Membership page: Subscribe to WPS Premium

Source: WPS Office pricing page

At a Glance

About This Feature

Overview

System Requirements

Download & Installation

Compare with Alternatives

Use Cases

Membership & Benefits

Free vs WPS Premium

Recommendations

How to Subscribe