How to Use the CELL Function in WPS on Windows

Last updated:July 17, 2026

Use the CELL function with 4 how-to topics; all 4 are available without membership and 0 are membership-related, so you can start from the index and follow the entry path and steps below.

How-to Index

No.TopicMembership
11. Enter the CELL functionFree
22. View the syntax promptFree
33. Fill in arguments and return a resultFree
44. Use it across worksheetsFree

How-to Guide

1. Enter the CELL function

Entry path: Formulas tab → formula bar

  1. Open Spreadsheet and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell.
  3. Type CELL( to begin the function.

Success Criteria

  • Interface result: The selected cell enters formula editing mode.
  • What you can do next: You can continue entering arguments and complete the formula.

Tips While Using

  • Start the formula with =.
  • It is helpful to enter the function in the result cell so the returned value is easy to review.

2. View the syntax prompt

Entry path: formula bar

  1. Keep the cell in editing mode after typing CELL(.
  2. Check the syntax prompt that appears automatically.
  3. Review the argument requirements and example shown in the prompt.

Success Criteria

  • Interface result: A function syntax prompt is visible.
  • What you can do next: You can continue entering arguments based on the prompt.

Tips While Using

  • If the prompt does not appear, re-enter the function name or confirm that the cell is still in editing mode.

3. Fill in arguments and return a result

Entry path: formula bar or cell

  1. Enter the correct arguments based on the syntax prompt.
  2. Check that parentheses and separators are complete.
  3. Press Enter to confirm the formula.
  4. Review the returned result in the cell.

Success Criteria

  • Interface result: The cell displays the result returned by CELL.
  • What you can do next: You can copy the formula, edit it further, or use it in other calculations.

Tips While Using

  • The argument type and count should match the function requirements.
  • Parentheses should be paired correctly.
  • In some versions, separators may appear differently, so follow the current in-product prompt.

4. Use it across worksheets

Entry path: formula bar

  1. Type =CELL( in the target cell.
  2. Switch to the worksheet you want to reference and select the related cell, or enter the reference manually.
  3. Complete the remaining arguments and press Enter.
  4. Review the result in the original cell and check whether it updates when the source data changes.

Success Criteria

  • Interface result: The formula includes a cross-worksheet reference.
  • What you can do next: The result can recalculate after the source cell changes.

Tips While Using

  • Confirm that the worksheet name and cell reference are correct.
  • If the result looks wrong, first check the content format of the referenced cell.