How to Use WPS Spreadsheet Numbering on Android

Use WPS Spreadsheet numbering on Android through 2 how-to topics, including creating a numbering field and generating numbers automatically; use the How-to Index below to jump to each topic, with 2 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Create a numbering field

Entry path: Tap the header → Edit → Field Type

1. Tap the header.
2. In the floating toolbar, tap Edit.
3. In the field editing window, tap Field Type.
4. Select the numbering field type.
5. Set the field name and confirm to finish creation.

Success Criteria

• Interface result: a new numbering field column appears in the data table.
• Next action available: new records can receive numbers automatically afterward.

Tips While Using

• Common mistake: if you choose the wrong field type, the created field may not work for automatic numbering.
• Environment note: available field types and entry names may depend on the current mobile interface.

2. Generate numbers automatically

Entry path: Numbers are generated when a new record is created

1. Add a new record in a data table that already contains a numbering field.
2. The system automatically generates an increasing number for that record.
3. As you continue adding records, the numbers increase in sequence.
4. Generated numbers cannot be edited manually.

Success Criteria

• Interface result: each new record shows a new numbering value.
• Next action available: you can continue reviewing, sorting, or tracking records by number.
• No side effect: if a record is deleted, its old number is not assigned again.

Tips While Using

• Common mistake: do not treat automatic numbering as a normal text column that can be edited manually.
• Environment note: Android does not support custom numbering rules or formats for this feature.