How to Use the PROPER Function in WPS on Windows

Last updated:July 20, 2026

Use PROPER through 3 task topics in WPS Spreadsheets on Windows; all 3 are available without membership, and you can start from the How-to Index below.

How-to Index

No.TopicMembership Requirement
11. Enter the PROPER functionFree
22. Check the syntax prompt and fill in the argumentFree
33. Review the result and recalculateFree

How-to Guide

1. Enter the PROPER function

Entry point: Formula tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing PROPER(.
  4. Get ready to enter the text value or cell reference you want to process.

Success Criteria

  • Interface result: The selected cell enters formula input mode.
  • Next action available: You can continue entering the argument and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content is treated as plain text instead of a formula.

2. Check the syntax prompt and fill in the argument

Entry point: Function input area in the formula bar

  1. After typing PROPER(, check the syntax prompt that appears.
  2. Enter the correct argument, such as a text string or a cell reference.
  3. Make sure the closing parenthesis is included.
  4. Press Enter to confirm the formula.

Success Criteria

  • Interface result: The cell shows a calculated result instead of raw formula text.
  • Next action available: You can copy the formula to other cells if needed.

Tips While Using

  • Common mistake: A missing closing parenthesis or incomplete argument can cause a formula error.

3. Review the result and recalculate

Entry point: Result cell → formula bar / keyboard shortcut

  1. Check whether the result is displayed with the first letter of each word capitalized.
  2. If the result is not what you expect, review the original text in the referenced cell.
  3. If the worksheet does not update in time, press F9 to trigger recalculation manually.
  4. After making corrections, review the result again.

Success Criteria

  • Interface result: The result cell shows the updated text format.
  • Next action available: You can continue editing, copying, or filling the formula.

Tips While Using

  • Common mistake: Special naming patterns in the original text can produce results that differ from your preferred style.
  • Environment note: The recalculation shortcut works when the spreadsheet window is active.