ROW: Reference Positions and Record Numbering in WPS Spreadsheet
Return a reference’s row number or the formula cell’s row with ROW. Build a positional sequence below headings without confusing it with permanent record IDs.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
ROW returns the worksheet row number of a reference, or the row containing the formula when the reference is omitted. It identifies a position. It does not count records, calculate the height of a range or create a permanent identifier for a person or transaction.
Syntax
=ROW([reference])
Reference is optional. The official lesson allows a cell or a contiguous cell range and excludes multiple-area references. It describes returning a range’s row numbers through vertical array entry. The examples here are scalar controls; they do not demonstrate dynamic spilling or a particular modern array-entry interface.
With no argument, the formula’s location matters. =ROW() in E8 is expected to return 8, while the same expression in E9 would describe row 9. An explicit reference instead asks about that reference wherever the formula is placed.
Reproducible examples
The explicit reference examples need no particular cell values. Place =ROW() in E8, and place =ROW()-2 specifically in A5.
| Formula | Independently expected result |
|---|---|
=ROW(A7) |
7 |
=ROW(C2) |
2 |
=ROW($F$20) |
20 |
=ROW(AA3) |
3 |
=ROW() |
8 |
=ROW()-2 |
3 |
The column letter does not affect the row index: AA3 is still row 3. Absolute markers in $F$20 influence copying, while its original row remains 20. These are address calculations, not inspections of the referenced cell’s text or number.
Practical case: numbering below headings
Suppose two heading rows occupy rows 1 and 2, and the first data record starts in row 3. The expression =ROW()-2 gives 1 in row 3, 2 in row 4 and 3 in row 5. This subtracts the known number of preceding heading rows from the actual worksheet position.
The official lesson uses this kind of numbering and discusses updates when rows are inserted or deleted. That makes it useful for positional display, but it is also why the result should not be used as a permanent record key. Sorting or restructuring the sheet can separate a record’s identity from its current position. Store a stable identifier separately when other records depend on it.
If the first record starts elsewhere, adapt the offset rather than copying −2 mechanically. For example, data beginning in row 7 requires a subtraction of 6 to start the displayed sequence at one. This follows from address arithmetic; no WPS editing operation was performed for this guide.
Troubleshooting and boundaries
An unexpected number often means the formula uses its own location instead of the intended target. Specify a reference when that distinction matters. Use ROWS when the question is the number of rows in a rectangular range rather than a row’s position.
The lesson does not establish automatic sequence filling for arbitrary array expressions, a dynamic spill contract, or the result of supplying disjoint references. Do not infer those capabilities from the vertical-array description. Similarly, a text string such as "A7" is different notation from the reference A7; text-to-reference conversion is not part of these examples.
Exact error displays for omitted versus malformed references, broken references and unsupported inputs are not enumerated by the source. Omission itself is valid for ROW, whereas an invalid supplied reference is a separate situation. Check the actual formula rather than treating every unexpected result as an application error.
Availability and evidence
The official WPS lesson is dated 2019-05-08 and explicitly labels its applicability WPS Office for Windows Personal. It does not identify a numeric release. This establishes documentation by that date, not the function’s original introduction or its last working version. Current build limits and equivalence across WPS clients remain unverified. The available evidence does not establish retirement or formal deprecation.
Checked October 18, 2026. The examples in this guide are original, independently calculated controls based on the lesson. They have not been run in WPS or another spreadsheet application. No screenshot or execution result is claimed.