How to Use WPS Percentage in Spreadsheet on Android

Last updated:July 24, 2026

Use Percentage in Spreadsheet through 3 how-to topics: create a percentage field, enter percentage values, and review summary statistics; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Create a Percentage FieldFree
22. Enter Percentage ValuesFree
33. Review Summary StatisticsFree

How-to Guide

1. Create a Percentage Field

Entry point: Tap the header → Edit → Field Type → Percentage

  1. Tap the header that you want to configure.
  2. In the floating toolbar, tap Edit.
  3. In the field editing window, tap Field Type.
  4. Select Percentage.
  5. Set the field name and confirm the change.

Success Criteria

  • Interface result: The new field or current field is shown as a percentage field.
  • What you can do next: You can enter percentage values in cells under that field.

Tips While Using

  • Common mistake: You cannot change the field type until you enter the field editing window.
  • Environment note: You need editing permission for the current table.

2. Enter Percentage Values

Entry point: Tap a cell in the percentage field

  1. Tap a cell under the percentage field.
  2. Enter a value, such as 50.
  3. Finish the input and check the displayed result.

Success Criteria

  • Interface result: After you enter 50, the cell displays 50%.
  • What you can do next: You can continue editing other cells or review statistics.

Tips While Using

  • Common mistake: If you enter a value in a non-percentage field, the percent sign is not added automatically.
  • Environment note: Set the field as Percentage before entering values.

3. Review Summary Statistics

Entry point: View the statistics area in a table that contains percentage fields

  1. Make sure the percentage field already contains data.
  2. Select or view the related data range.
  3. Check the sum, average, or other results in the status bar or statistics area.

Success Criteria

  • Interface result: You can see summary results that include the percentage field.
  • What you can do next: You can continue adjusting entered values based on the results.

Tips While Using

  • Common mistake: Too many blank cells may affect how complete the statistics appear.
  • Environment note: The location of the statistics area may vary with the current layout.