How to Use WPS Table Styles on macOS

Use WPS Table Styles through 6 how-to topics, including 4 free topics and 2 membership-related items; choose a topic from the index and complete it from Home or Table Tools.

How-to Index

How-to Guide

1. Apply preset table styles

Feature entry: Home tab → Apply Table Style drop-down menu

1. Click the Home tab.
2. Open the Apply Table Style drop-down menu.
3. Select the table style you want.
4. Check whether the table updates immediately.

Success Criteria

• Interface result: the current table shows the new color and formatting style.
• What you can do next: you can switch to another style or save the file.

Tips While Using

• Some preset styles are membership-related.

2. Create a new table style

Feature entry: Home tab → Apply Table Style drop-down menu → New Table Style

1. Click the Home tab.
2. Open the Apply Table Style drop-down menu.
3. Click New Table Style.
4. Set the formatting for each element in the dialog box.
5. Enter a style name and click OK.

Success Criteria

• Interface result: the new custom style appears in the style gallery.
• What you can do next: you can apply it to the current table or later tables.

3. Create a new PivotTable style

Feature entry: Home tab → Apply Table Style drop-down menu → New PivotTable Style

1. Click the Home tab.
2. Open the Apply Table Style drop-down menu.
3. Click New PivotTable Style.
4. Set the formatting for each element in the dialog box.
5. Enter a style name and click OK.
6. Select the new style in the PivotTable.

Success Criteria

• Interface result: the new style appears in the PivotTable style list.
• What you can do next: you can apply it directly in a PivotTable.

4. Clear a table style

Feature entry: Home tab → Apply Table Style drop-down menu

1. Click the Home tab.
2. Open the Apply Table Style drop-down menu.
3. Select None in the style gallery.
4. Confirm that the table returns to a no-style state.

Success Criteria

• Interface result: the table no longer shows the applied style effect.
• What you can do next: you can apply another style or keep the current plain format.

5. Modify an existing custom style

Feature entry: Home tab → Apply Table Style drop-down menu → Custom → right-click a style → Modify

1. Click the Home tab.
2. Open the Apply Table Style drop-down menu.
3. Go to the Custom area.
4. Right-click the style you want to edit and choose Modify.
5. Adjust the formatting and click OK.

Success Criteria

• Interface result: the selected custom style updates with the new formatting.
• What you can do next: you can keep using the updated style in tables.

Tips While Using

• Only table styles you created yourself can be modified.
• If a style involves membership-related content, confirm your account benefits first.

6. Set a table style from Table Tools

Feature entry: Table Tools tab → Apply Table Style drop-down menu

1. Select any cell in the table.
2. Click the Table Tools tab.
3. Open the Apply Table Style drop-down menu.
4. Select the style you want and apply it to the table.

Success Criteria

• Interface result: the table shows the selected style effect.
• What you can do next: you can continue editing the table or switch to another style.

Tips While Using

• Some styles are membership-related.