WPS Features
Resources
Free AI Tools
Docs Center

How to Use the LOWER Function in WPS on Windows

Last updated:July 13, 2026

Use the LOWER function through 3 how-to topics, all available directly in WPS Spreadsheet; choose a topic from the How-to Index and follow the steps to complete the task.

How-to Index

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

How-to Guide

1. Insert LOWER 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 LOWER in the dialog box.
  4. Select the function and confirm.
  5. Enter the text value or cell reference in the function parameter dialog.
  6. Confirm to insert the function.

Success Criteria

  • The cell contains a =LOWER(...) formula.
  • The formula returns a calculated result after confirmation.
  • Uppercase letters in the result are converted to lowercase.

Tips While Using

  • The argument should be text content or a cell reference that contains text.
  • Non-letter characters usually remain unchanged.
  • If you need batch processing, fill the formula down after the first result is correct.

2. Type a LOWER formula directly in a cell

Entry point: Cell or formula bar

  1. Select the cell where you want the result to appear.
  2. Type =LOWER(A1) or another target cell reference.
  3. Press Enter to confirm.
  4. If you need to process more rows, drag the fill handle to copy the formula.

Success Criteria

  • The current cell shows the converted lowercase result.
  • The formula bar shows the full LOWER formula.
  • Filled cells in other rows return corresponding results.

Tips While Using

  • Make sure the referenced cell contains text.
  • When filling formulas down, check whether relative references behave as expected.
  • If needed, adjust the reference style for fixed positions.

3. Review LOWER syntax and parameter guidance

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Enter LOWER in the search box.
  3. Select the function and review the syntax and parameter area.
  4. Confirm the parameter meaning shown in the interface before inserting the function.

Success Criteria

  • You can see the LOWER function name and parameter input area.
  • You can confirm the formula format before insertion.
  • The inserted formula can participate in calculation normally.

Tips While Using

  • If you are unsure about the parameter format, the Insert Function entry is easier for checking details.
  • If the result looks incorrect, first check the content in the referenced cell.