WPS Features
Resources
Free AI Tools
Docs Center

How to Use the SHEETS Function in WPS on Windows

Last updated:July 13, 2026

Use the SHEETS function in WPS on Windows through 3 operation topics, all available on the Windows desktop, with 3 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Enter the function from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review the function syntax and parameter guidanceFree

How-to Guide

1. Enter the function from the Insert Function dialog box

Entry: Formula 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 Formula tab.
  3. Search for SHEETS in the dialog box.
  4. Select the function and click OK.
  5. Enter the reference argument as needed, or leave it empty if appropriate.
  6. Click OK to insert the function.

Success Criteria

  • The SHEETS function is inserted into the selected cell.
  • The cell returns a worksheet count after confirmation.

Tips While Using

  • The reference argument should point to a valid worksheet, range, or related reference.
  • If the argument is invalid, the formula may return an error.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

  1. Select the target cell.
  2. Type =SHEETS(...) directly in the cell or in the formula bar.
  3. To count the worksheets in the current workbook, type =SHEETS().
  4. Press Enter to confirm.

Success Criteria

  • The cell displays the calculated result.
  • The formula bar shows the full SHEETS formula.

Tips While Using

  • Start the formula with an equal sign.
  • Keep the parentheses and reference format correct.

3. Review the function syntax and parameter guidance

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Type SHEETS in the search box.
  3. Select the function to review its syntax and parameter guidance.
  4. Confirm whether the reference argument is needed before inserting the formula.

Success Criteria

  • You can see the SHEETS function name, syntax, and parameter area.
  • You can continue to insert or revise the formula based on the guidance.

Tips While Using

  • The syntax panel helps confirm whether the argument can be omitted.
  • Confirm the reference target before final entry to reduce formula errors.