How to Use WPS Table Styles on Android

This guide includes 4 how-to topics for WPS Table Styles on Android, covering preset styles, header or first-column fill, last-row or last-column fill, and banded rows or columns; 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Apply a preset table style

Entry path: Bottom Tools > Home tab > Table Styles

1. Open the spreadsheet file that you want to edit.
2. Select the table range, preferably including the header row.
3. Tap Tools at the bottom.
4. Open the Home tab.
5. Tap Table Styles.
6. Select the style you want and tap OK.

Success Criteria

• Interface result: The selected range shows the new table appearance.
• What you can do next: You can continue editing cells or adjust the style again.

Tips While Using

• Common mistake: If you do not select the table range first, the style may not apply as expected.
• Environment note: It is recommended to include the full header row so the style effect is clearer.

2. Set header row or first column fill

Entry path: Bottom Tools > Home tab > Table Styles

1. Select the table range that you want to format.
2. Tap Tools and open Home.
3. Tap Table Styles.
4. Select Header Row or First Column.
5. Tap OK to finish.

Success Criteria

• Interface result: The first row or first column shows the selected fill effect.
• What you can do next: You can continue adding other style options.

Tips While Using

• Common mistake: If the selected range is incomplete, the visible header row or first column effect will follow the current selection.

3. Set last row or last column fill

Entry path: Bottom Tools > Home tab > Table Styles

1. Select the table range.
2. Open the Table Styles settings panel.
3. Select Last Row or Last Column.
4. Tap OK.

Success Criteria

• Interface result: The last row or last column shows the fill effect.
• What you can do next: You can continue changing the style or save the file.

Tips While Using

• Common mistake: If the last row or last column contains blank cells, the visual effect may be less obvious.

4. Set banded rows or banded columns

Entry path: Bottom Tools > Home tab > Table Styles

1. Select the table range.
2. Tap Tools and open Home.
3. Tap Table Styles.
4. Select Banded Rows or Banded Columns.
5. Tap OK.

Success Criteria

• Interface result: The table shows alternating row shading or alternating column shading.
• What you can do next: You can continue reviewing data, editing content, or saving the file.

Tips While Using

• Common mistake: Banded row and banded column effects depend on the current selected range, so you can reselect the range and adjust them again if needed.