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 to use
Version Restriction No version restriction

Operation Steps

Table Styles (Some styles require a membership)

Feature Entry
"Home" tab → "Apply Table Style" dropdown menu

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

image

Create New Table Style

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

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

image

Create New PivotTable Style

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

  1. Click the Home tab
  2. Click the "New PivotTable Style" button in the Apply Table Style dropdown menu
  3. Set the format 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

image

Clear Table Style

Feature Entry
"Home" tab → "Apply Table Style" dropdown menu

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

image

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

Feature Entry
"Table Tools" tab → "Apply Table Style" dropdown menu

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

image

FAQ

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