Feature Summary

The Theme feature allows you to uniformly set the font, color, and effect style of a spreadsheet with one click, quickly achieving a visually consistent and polished spreadsheet design.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Apply Built-in Themes

Feature Entry
"Page" tab → "Themes" dropdown list → "Themes" button

  1. Click the "Themes" dropdown list in the Page tab
  2. Select the "Themes" button in the dropdown list
  3. Choose a preset theme style from the menu
  4. Click the selected theme to uniformly modify the spreadsheet's font, color scheme, and effect style with one click

image

Set Theme Colors

Feature Entry
"Page" tab → "Themes" dropdown list → "Colors" button

  1. Click the "Themes" dropdown list in the Page tab
  2. Select the "Colors" button in the dropdown list
  3. Choose a preset color style from the menu

image

Set Theme Fonts

Feature Entry
"Page" tab → "Themes" dropdown list → "Fonts" button

  1. Click the "Themes" dropdown list in the Page tab
  2. Select the "Fonts" button in the dropdown list
  3. Choose a preset font style from the menu

image

Apply Theme Effects

Feature Entry
"Page" tab → "Themes" dropdown list → "Effects" button

  1. Click the "Themes" dropdown list in the Page tab
  2. Select the "Effects" button in the dropdown list
  3. Choose a theme effect from the menu

image

FAQ

Q1: Will manually set formatting be overwritten after applying a theme?

  • Solution: It will not be completely overwritten. The theme modifies global styles such as fonts and color schemes, but manually set cell formatting (such as bold or merged cells) will be retained.

Notes

  • Themes apply to the entire workbook and can affect the appearance of multiple worksheets simultaneously
  • Using themes in combination with table styles allows you to quickly create professional reports