How to Use WPS Table Styles on Windows

Use Table Styles through 6 how-to topics, including 4 free topics and 2 membership-related topics; choose a topic from the index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Apply a preset table style

Feature entry: Home tab → Table Styles drop-down menu

1. Click the Home tab.
2. Open the Table Styles drop-down menu.
3. Select the style you want.
4. The selected style is applied to the table immediately.

Success Criteria

• The table shows the new formatting and color scheme.
• The style change is visible right away.

Tips While Using

• Some preset styles require WPS Premium.
• Select the target table first so the result is easier to confirm.

2. Create a new table style

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

1. Click the Home tab.
2. Open Table Styles and click New Table Style.
3. Set the formatting for each element in the dialog box.
4. Enter a style name.
5. Click OK to finish.

Success Criteria

• The new style appears in the style library.
• You can apply it again later in the same workbook.

Tips While Using

• Use a clear style name for easier reuse.
• It helps to define header and data area formatting before saving the style.

3. Create a new PivotTable style

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

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

Success Criteria

• The new style is available in the PivotTable style list.
• The PivotTable displays the expected formatting.

Tips While Using

• This is useful for recurring analysis templates.
• Confirm the PivotTable structure before finalizing the style details.

4. Clear a table style

Feature entry: Home tab → Table Styles drop-down menu

1. Click the Home tab.
2. Open the Table Styles drop-down menu.
3. Select None from the style gallery.

Success Criteria

• The table returns to a plain style state.
• The previous style appearance is removed.

Tips While Using

• After clearing the style, you can apply a different one.
• If you want to preserve the current look, duplicate the worksheet first.

5. Modify an existing custom style

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

1. Click the Home tab and open Table Styles.
2. Go to the Custom section.
3. Right-click the style you want to edit.
4. Select Modify.
5. Adjust the formatting and click OK.

Success Criteria

• The updated style is saved.
• The revised formatting appears when the style is used again.

Tips While Using

• Only styles you created yourself can be modified.
• Check whether the style is already used in other tables before changing it.

6. Apply a style from Table Tools

Feature entry: Table Tools tab → Table Styles drop-down menu

1. Select any cell inside the inserted table.
2. Click the Table Tools tab.
3. Open the Table Styles drop-down menu.
4. Select the style you want to apply.

Success Criteria

• The Table Tools entry is visible after the table is selected.
• The selected style is applied to the table.

Tips While Using

• Some styles require WPS Premium.
• This entry is convenient when you are already working inside a table.