Use Table Styles through 4 how-to topics, including applying a table style and setting first-row or first-column emphasis; choose a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Apply a Table Style | Free |
| 2 | 2. Set First-Row or First-Column Fill | Free |
| 3 | 3. Set Last-Row or Last-Column Fill | Free |
| 4 | 4. Set Alternating Row or Alternating Column Fill | Free |
How-to Guide
1. Apply a Table Style
Entry path: Bottom toolbar → Tools → Home → Table Styles
- Select the table range, preferably including the header row.
- Tap Tools on the bottom toolbar.
- Open the Home tab.
- Tap Table Styles.
- Select the style you want.
- Tap OK to apply it.
Success Criteria
- Visual result: The selected range shows the new table style.
- Next step available: 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: Open a worksheet in WPS Spreadsheet that contains the target table data.
2. Set First-Row or First-Column Fill
Entry path: Bottom toolbar → Tools → Home → Table Styles
- Select the target table range.
- Open Table Styles.
- Select First Row Fill to emphasize the first row, or select First Column Fill to emphasize the first column.
- Tap OK to apply the setting.
Success Criteria
- Visual result: The first row or first column is shown with clearer emphasis.
- Next step available: You can continue adjusting other style options.
Tips While Using
- Common mistake: If the header is not included in the selection, first-row emphasis may not highlight the intended header content.
3. Set Last-Row or Last-Column Fill
Entry path: Bottom toolbar → Tools → Home → Table Styles
- Select the full table range.
- Tap Table Styles.
- Select Last Row Fill or Last Column Fill.
- Tap OK to save the style setting.
Success Criteria
- Visual result: The last row or last column shows a separate fill effect.
- Next step available: You can continue entering totals or result values.
Tips While Using
- Common mistake: If the selected range extends beyond the actual data, the last-row or last-column effect may appear in blank cells.
4. Set Alternating Row or Alternating Column Fill
Entry path: Bottom toolbar → Tools → Home → Table Styles
- Select the table range you want to format.
- Open Table Styles.
- Select Alternating Row Fill or Alternating Column Fill.
- Preview the alternating effect.
- Tap OK to finish.
Success Criteria
- Visual result: The table shows alternating row or alternating column fills.
- Next step available: The table becomes easier to review, check, and present.
Tips While Using
- Common mistake: If the table has only a few columns, alternating column fills may look less obvious.