Use WPS Document Settings with 4 how-to topics; all 4 are available without membership, and you can start from the index below to complete each setup task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Open the Document Settings page | Free |
| 2 | 2. Set the cell editing mode | Free |
| 3 | 3. Set tap behavior for a selected cell | Free |
| 4 | 4. Keep the input bar always visible | Free |
How-to Guide
1. Open the Document Settings page
Entry path: Menu → Document Settings → Settings
- Open your spreadsheet on Android.
- Tap the Menu button in the upper-right corner.
- Tap Document Settings in the drop-down menu.
- Tap Settings to open the page.
Success Criteria
- Interface result: The Document Settings page opens and shows spreadsheet input-related options.
- What you can do next: You can continue to adjust editing mode, tap behavior, or input bar display.
Tips While Using
- Common mistake: If you have not opened a spreadsheet first, the entry may not appear.
- Environment note: This entry is in the upper-right menu on Android.
2. Set the cell editing mode
Entry path: Document Settings → Cell Editing Mode
- Open the Document Settings page.
- Find Cell Editing Mode.
- Choose either Keep input status when switching cells or Switch to selected status when switching cells.
- Return to the sheet and continue working.
Success Criteria
- Interface result: The selected mode is shown as active.
- What you can do next: When you move to another cell, the sheet responds according to the selected mode.
Tips While Using
- Common mistake: In continuous entry scenarios, choosing selected status by mistake may add an extra tap before editing.
- Environment note: Different tasks may fit different modes, so adjust it based on your current workflow.
3. Set tap behavior for a selected cell
Entry path: Document Settings → Tap Behavior for Selected Cell
- Open the Document Settings page.
- Find Tap Behavior for Selected Cell.
- Choose either Enter editing status or Show cell menu.
- Return to the sheet and tap a selected cell to verify the result.
Success Criteria
- Interface result: The selected tap behavior is active.
- What you can do next: Tapping a selected cell again either opens editing or shows the cell menu.
Tips While Using
- Common mistake: If you want faster text entry, make sure the current option is not set to show the cell menu.
- Environment note: This setting changes how a selected cell responds when tapped again.
4. Keep the input bar always visible
Entry path: Document Settings → Always Show Input Bar
- Open the Document Settings page.
- Find the Always Show Input Bar switch.
- Turn it on to keep the input bar visible.
- Turn it off again if you want more screen space.
Success Criteria
- Interface result: When enabled, the input bar stays visible; when disabled, it appears only during editing.
- What you can do next: You can switch between easier continuous entry and a cleaner viewing area.
Tips While Using
- Common mistake: On smaller screens, keeping the input bar visible uses part of the display area.
- Environment note: This setting mainly affects mobile input experience.