DROP in WPS Spreadsheet: Remove Leading Rows and Columns from an Array Result
Trim a WPS array with positive DROP counts and distinguish input headers from records using a worked example table.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =DROP(A1:C5,1) returns the rows after the first source row. =DROP(A1:C5,1,1) also excludes the first source column. These formulas create result arrays; they are not commands to delete worksheet rows or columns.
Syntax and bounded arguments
=DROP(array,rows,[columns])
Square brackets mark the optional columns argument; do not type them in a formula.
In the demonstrated positive-count cases, rows is the number of leading source rows excluded and columns is the number of leading source columns excluded. The video also demonstrates a two-argument call that retains all source columns. This guide does not generalize from that example to every possible omitted argument.
Example 1: separate records from a heading row
Enter A1:C5 exactly as follows:
| Row | A | B | C |
|---|---|---|---|
| 1 | Item | Units | Price |
| 2 | Pen | 12 | 2.5 |
| 3 | Pad | 8 | 4 |
| 4 | Clip | 30 | 0.2 |
| 5 | Tape | 6 | 3 |
In E1, in a separate clear area, enter =DROP(A1:C5,1). The independently expected E1:G4 contains:
| E | F | G |
|---|---|---|
| Pen | 12 | 2.5 |
| Pad | 8 | 4 |
| Clip | 30 | 0.2 |
| Tape | 6 | 3 |
Five source rows minus one leading row gives four output rows. No source records are removed from the worksheet. The formula’s input includes the header, so its one removed row is the header.
Advanced case: trim both dimensions
Use =DROP(A1:C5,2,1) in E7. Remove the first two rows, meaning the header and Pen, then exclude the first column, Item. The expected 3-by-2 result is 8, 4 / 30, 0.2 / 6, 3 in E7:F9. Check the dimensions independently: 5 − 2 = 3 rows; 3 − 1 = 2 columns.
If the goal is to omit only the first data record while retaining all fields, use the header-free source: =DROP(A2:C5,1). It produces Pad, 8, 4 / Clip, 30, 0.2 / Tape, 6, 3. This is a different range from the first example and deliberately keeps the header outside the calculation.
Source correction: two examples have different ranges
The official first formula is =DROP(A2:E21,5) and its result begins with item 6. The second completed formula at 60.226 seconds is =DROP(A1:E21,5,3), even though its subtitle says A2:E21. The second result begins 2.37, 1185, the last two fields of item 5, because the header counts among the five removed rows. These results are consistent with the formula bars, not with treating both source ranges as identical.
Troubleshooting and limits
- Count all rows in the reference, including headers or notes, before deciding how many to drop.
- A smaller result is expected; the original source remains present.
- Use counts smaller than the corresponding dimensions in these examples, leaving a nonempty result.
- Negative counts, zero, fractional or excessive counts, omitted
rows, empty-result behavior and exact error messages are not established by these demonstrations. - Confirm array expansion in the target installation. This guide does not import Excel spill operators or collision rules.
Related functions
Availability and version evidence
The official WPS DROP lesson and its linked video show a Chinese-language WPS spreadsheet interface with a WPS AI label. The actual demonstration was reviewed on October 19, 2026. No numeric build, exact edition, operating system, license or release-date label was verified. This is genuine historical product evidence, not an introduction-version claim or proof of support in every current desktop, web or mobile edition.
The video shows an array result occupying neighboring cells. Confirm function recognition and array entry in your intended installation before sharing a workbook. Spill rules, argument defaults beyond the demonstrated forms and exact errors are not established here. Original example outputs were independently checked as array transformations, not executed in an installed WPS build.
References and verification
The cited timestamps refer to the official lesson video.