How to Use the LOWER Function in WPS on Windows

Last updated:July 20, 2026

Use the LOWER function through 1 how-to topic, with 1 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Use the LOWER functionFree

How-to Guide

1. Use the LOWER function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = in the selected cell or in the formula bar.
  3. Enter LOWER( and review the syntax prompt.
  4. Type a text value or a cell reference, such as LOWER(A2).
  5. Type the closing parenthesis ) and press Enter to return the lowercase result.

Success Criteria

  • Interface result: The target cell shows the converted lowercase text.
  • Next action available: You can fill down, copy the formula, or edit the argument.
  • No side effect: The original source cell is not overwritten directly.

Tips While Using

  • Common mistake: Missing quotation marks or parentheses can cause a formula error.
  • Environment note: If the referenced cell is empty, the result follows the source cell state.