Use WPS Table Styles on iOS with 3 how-to topics; all 3 are available without membership, and you can jump from the index to the task you need.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Apply a table style | Free |
| 2 | 2. Adjust table style options | Free |
| 3 | 3. Clear an applied table style | Free |
How-to Guide
1. Apply a table style
Entry path: Bottom toolbar → Tools → Home tab → Table Styles
- Open the spreadsheet file that contains the target table.
- Select the table range and make sure the header row is included.
- Tap Tools on the bottom toolbar.
- Open the Home tab.
- Tap Table Styles.
- Select the style you want to use.
- Tap OK to apply it.
Success Criteria
- Interface result: The selected range shows the new table style.
- What you can do next: You can continue editing cells or save the file.
Tips While Using
- Common mistake: If the full table range is not selected, the style may apply to only part of the table.
- Environment note: Including the header row helps the header style display correctly.
2. Adjust table style options
Entry path: Bottom toolbar → Tools → Home tab → Table Styles
- Select the table range you want to format.
- Tap Tools and open the Home tab.
- Tap Table Styles.
- Turn on or choose the effects you need, such as header row fill, first column fill, last row fill, last column fill, banded rows, and banded columns.
- Preview the result and tap OK.
Success Criteria
- Interface result: The table displays the selected row or column styling effects.
- What you can do next: You can continue adjusting other formatting or share the file.
Tips While Using
- Common mistake: Turning on too many fill effects at the same time can make the table look busy.
- Environment note: Banded rows and banded columns may look different depending on table density and content length.
3. Clear an applied table style
Entry path: Select the related table range, then use the clear formatting option
- Select the range that already has a table style applied.
- Open the related formatting tools.
- Tap Clear Formatting.
- Check whether the table has returned to a plain appearance.
Success Criteria
- Interface result: The applied table style appearance is removed.
- What you can do next: You can apply another style or continue editing data.
Tips While Using
- Common mistake: If only part of the table is selected, only that selected area will be cleared.