WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ROW Function in WPS on Windows

Last updated:July 13, 2026

This how-to guide includes 3 topics: inserting ROW from the Insert Function dialog, typing the formula directly in a cell, and reviewing syntax and parameter guidance; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Insert ROW from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter guidanceFree

How-to Guide

1. Insert ROW from the Insert Function dialog

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for ROW in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell now contains the ROW function.
  • The formula bar shows the function expression.
  • The worksheet returns a row number result.

Tips While Using

  • Use the standard function name ROW when searching.
  • If you are unsure about the parameters, review the function guidance before confirming.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =ROW(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm the formula.
  4. If you want to review parameter guidance, type =ROW( and then press F1 to check the syntax prompt.

Success Criteria

  • The cell displays a calculation result.
  • The formula bar keeps the full formula content.
  • The worksheet completes the calculation after you press Enter.

Tips While Using

  • Use the English function name and standard parentheses.
  • If you reference a cell or range, check that the reference points to the intended location.

3. Review syntax and parameter guidance

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter ROW in the search box.
  3. Select the function and review the syntax ROW(...).
  4. Click the help link for the function to open more detailed guidance.

Success Criteria

  • The ROW function information area or help entry opens.
  • You can review syntax and parameter details.
  • You can continue entering or adjusting the formula based on that guidance.

Tips While Using

  • The exact layout of the help area may vary by version.
  • If the help link does not open, check your network connection first.