How to Use the LOWER Function in WPS on Windows

Last updated:July 17, 2026

Use LOWER with 1 how-to topic: Use the LOWER function. Open the How-to Index, choose the topic, and follow the entry point and steps to complete the task.

How-to Index

#TopicMembership
11. Use the LOWER functionFree

How-to Guide

1. Use the LOWER function

Entry point: Formulas tab → formula bar

  1. Open WPS Office Sheets and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell to start the formula.
  3. Enter LOWER( and review the syntax prompt and parameter example.
  4. Enter the correct parameter, close the parenthesis, and press Enter.
  5. Check the result in the cell. When the referenced text changes, the result updates automatically.

Success Criteria

  • UI state: The cell displays the converted lowercase text result.
  • Next actions: You can copy the formula, fill it down, or combine it with other functions.

Tips While Using

  • Common mistakes: Entering the function without = or leaving parentheses incomplete.
  • Environment limits: The parameter should be text or content that can be treated as text.