DROP in WPS on Windows: Introduction

WPS DROP is a function in WPS Office for Windows AirSheet that removes a specified number of rows or columns from the start 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
Version limits	None	Available in AirSheet across supported versions

About This Feature

Overview

DROP is a commonly used function in WPS Office for Windows AirSheet for data calculation and analysis. It removes a specified number of rows or columns from the beginning of an array result and returns the remaining data. You can enter it directly in the formula bar and view syntax tips, parameter guidance, and examples while typing.

Core capabilities include:

Quickly using the DROP function for data calculations.
Flexible parameters for different calculation scenarios.
Supporting cross-sheet references and nested calculations.
Updating results automatically when source data changes.

System Requirements

Item	Requirement
OS	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 internet connection is required for local function calculations; internet access is needed for download and installation
Other	You need to be able to open AirSheet and edit formulas in cells

Download & Installation

Before using DROP, install WPS Office on your Windows device and open AirSheet.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office → open AirSheet → select any cell and type `=DROP(` to confirm that function syntax tips appear

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In AirSheet, you can type `=DROP(` to use the function and view syntax tips, examples, cross-sheet references, and nested calculation support.	Excel provides the DROP function to exclude a specified number of rows or columns from the start of an array and return the remaining result.	Google Sheets provides the DROP function to remove a specified number of rows or columns from the start of an array.	Notion formulas support list operations and formula logic, but the official help page does not describe a spreadsheet-style DROP function with the same array-trimming behavior.	Acrobat focuses on PDF automation, actions, and scripts, and its official page does not describe a spreadsheet DROP function.
WPS Advantages	Advantage: On Windows, WPS lets you enter DROP directly in the formula bar and review syntax tips while working; it also supports cross-sheet references and nested calculations for ongoing spreadsheet analysis.	Compared with WPS: Excel also offers a direct DROP function for dynamic array workflows.	Compared with WPS: Google Sheets offers the same function name and is suited to browser-based collaboration.	Compared with WPS: Notion is more focused on page and database formulas than spreadsheet-style function entry.	Compared with WPS: Adobe centers on PDF workflows rather than spreadsheet function calculations.
Official Source	—	DROP function	DROP	Formulas	Applying actions and scripts to PDFs

Overall Conclusion
For users who want to work with array formulas in a Windows spreadsheet environment, WPS DROP provides direct formula entry and in-context syntax guidance. Microsoft and Google offer comparable DROP functions, while Notion and Adobe are better suited to page-based workflows or PDF tasks.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Cleaning initial rows or columns from array results	Data analysts	Formula results include extra rows or columns at the beginning that are not needed	Use DROP to remove the beginning of the array and keep the target result
2	Combining dynamic array formulas	Advanced spreadsheet users	Results become too long after combining multiple array functions	Nest DROP with other functions to keep only the needed portion
3	Organizing data across sheets	Finance and operations teams	Results need additional trimming after cross-sheet references	Use DROP with cross-sheet references to adjust the returned range
4	Reviewing formula syntax during editing	Office users	Parameter format is unclear while entering a function	Type `=DROP(` to view syntax tips and examples
5	Updating recurring reports automatically	Weekly and monthly report creators	Recalculating after source data changes takes extra time	Include DROP in formulas so results update automatically with the data

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Use the DROP function	✅	✅
Formula syntax tips	✅	✅
Cross-sheet references and nested calculations	✅	✅

Recommendations

Use Case	Recommended Plan	Reason
Everyday spreadsheet calculations and learning functions	Free	DROP itself has no membership restriction and can be used directly
Broader office scenarios that also need added membership benefits	WPS Member	Suitable for users who also want additional membership features across WPS Office

WPS membership center: Subscribe now

Source: WPS Office pricing page