WPS Sheets Table Style Feature User Guide

Feature Summary

The Table Style feature provides a variety of preset table beautification schemes, allowing you to quickly apply professional color schemes and formatting to tables, making them more attractive and easier to read.

Feature Description

Feature Dimension	Description
Membership Restriction	Some preset styles require a membership subscription to use
Version Restriction	No version restrictions

Operation Steps

Table Styles (Some styles require a membership subscription)

Feature Entry
"Home" tab → "Table Styles" dropdown menu

1. Click the Home tab
2. Select your preferred style from the "Table Styles" dropdown menu
3. The table will immediately apply the selected style

Create New Table Style

Feature Entry
"Home" tab → "Table Styles" dropdown menu → "New Table Style" button

1. Click the Home tab
2. Click the "New Table Style" button in the Table Styles dropdown menu
3. Set the formatting for each element in the dialog box
4. Enter a style name and click OK to complete creation

Create New PivotTable Style

Feature Entry
"Home" tab → "Table Styles" dropdown menu → "New PivotTable Style" button

1. Click the Home tab
2. Click the "New PivotTable Style" button in the Table Styles dropdown menu
3. Set the formatting for each element in the dialog box
4. Enter a style name and click OK to complete creation. The newly created style can then be selected in the PivotTable.

Clear Table Style

Feature Entry
"Home" tab → "Table Styles" dropdown menu

1. Click the Home tab, then click the Table Styles dropdown menu
2. Select "None" from the style gallery
3. The table will revert to having no style applied

Modify Existing Style

Feature Entry
"Home" tab → "Table Styles" dropdown menu → "Custom" tab → Right-click a style → "Modify" option

1. Click the Home tab, then click the Table Styles dropdown menu
2. Click the Custom tab, then right-click the style you want to modify
3. Select the "Modify" option
4. Modify the formatting settings
5. Click OK to save the changes

Only table styles you have created yourself can be modified

Set Table Style in Table Tools (Some styles require a membership subscription)

Feature Entry
"Table Tools" tab → "Table Styles" dropdown menu

1. Select any cell within the inserted table
2. Click the Table Tools tab
3. Click the "Table Styles" dropdown menu to set the table style
4. The table will apply the selected style

Frequently Asked Questions

Q1: How to make table rows alternate in color?

• Solution: After applying a table style, check "Banded Rows" in the "Table Style Options" to achieve alternating row colors.

Q2: Can table styles be saved?

• Solution: Yes. Newly created table styles are saved in the style gallery and can be reused in the current document.

Q3: How to delete a custom table style?

• Solution: Right-click the custom style in the table style gallery and select "Delete".

Notes

1. Table styles can quickly beautify tables
2. Banded rows/columns can make data easier to read
3. Custom styles can improve work efficiency