在Excel 中^(Excel)，主题^(Theme)是默认颜色^(Colors)、字体^(Fonts)和效果^(Effect)的集合，可以添加到工作簿或工作簿中的项目，例如表格^(Tables)和图表^(Charts)。每个主题^(Theme)都提供独特的颜色、字体^{(Color, Font)}和效果^(Effects)，为文档提供一致的专业外观。选择新主题^(Theme)后，新样式将替换工作簿中的任何样式。

主题组^{(Theme Group)}中的页面布局^{(Page Layout)}选项卡中提供了创建主题^(Themes)的工具。这些工具是主题^(Themes)、颜色^(Colors)、字体^(Font)和效果^(Effect)。

• 主题^(Themes)：主题为您的工作簿提供一致、有吸引力的风格
• 颜色^(Color)：通过单击调色板更改文档中的颜色
• 字体^(Font)：通过选择字体集更改工作簿中的文本。它同时更改您的文档文本。
• 效果^(Effects)：它改变了工作簿中对象的外观。它使用视觉效果。

将鼠标悬停在主题组中的主题^{(Themes Group)}工具^{(Theme’s Tools)}上，您可以预览它们在工作表上的外观。

在本教程中，我们将解释如何在Excel中选择和自定义您的工作簿。

如何将主题^(Themes)添加到Excel 工作簿^{(Excel Workbook)}

要将主题^{(Themes) (Themes )}添加到工作簿中，请确保数据位于表中，风格正常是正常的，因为在所选应用程序上时，您不会看到主题调色板。^{(Theme Palette)}

首先，转到页面布局窗口^{(Page Layout Window)}左上角的页面布局^{(Page Layout)}选项卡，选择主题^(Themes)。在主题^{(Theme )}组^(Group)中，一个下拉列表将显示选择您想要的主题^(Theme)。选择主题^(Theme)后，您会注意到工作表中的样式和颜色如何变化。

您还可以浏览主题。选择Browse for Themes，您的文件资源管理器^{(File Explorer)} 窗口^(window)将弹出。选择您下载的主题^(Theme)并将其添加到您的表格中。然后确定^(OK)。您还可以通过选择 Save Current Theme来^(Theme)保存您的主题。主题^(Theme)将保存到文件资源管理器^{(File Explorer)}中，命名您的主题^(Theme)，选择您希望主题所在的^(Theme)文件夹^(Folder)，然后保存^(Save)。

将主题颜色添加到您的工作簿

转到页面布局^{(Page Layout)}选项卡上的主题组^{(Themes Group)}并选择颜色，将出现一个^(Colors)调色板^{(Color Palettes)}列表，然后选择您想要的调色板；^{(Color Palette)}注意只有工作表中表格内的颜色发生了变化。

您还可以通过选择自定义颜色来自定义颜色^{(Customized Colors)}。将出现一个名为“创建新主题颜色^{(Create New Theme Colors)}”的对话框；选择您的颜色^(Colors)或Text/ Background Colors，然后确定^(O)。图片中显示的表格中的主题^(Theme)将改变。

将字体添加到 Excel 工作簿

转到主题组中的^{(Theme Group)}页面布局^{(Page Layout)}选项卡。选择字体^(Fonts)，选择你想要的字体^(Font)。请注意，表格中的^(Table)字体样式^{(Font Style)}发生了变化。

您还可以通过单击自定义字体^{(Customized Fonts)}来自^(Font)定义您的字体。将出现一个名为Create New Theme Fonts^{(Create New Theme Fonts)}的对话框。单击标题和正文字体^{(Heading and Body Font)}的下拉箭头。您将看到可以从Microsoft Store下载的^{(Microsoft Store)}字体样式^{(Fonts Styles)}。选择您想要的样式，然后命名您的样式，然后确定。

将效果添加到您的工作簿对象

在主题组^{(Themes Group)}中，选择页面布局^{(Page Layout)}选项卡上的效果，^(Effect)将出现效果列表。^(Effects)选择  你想要的效果，然后^(Effect)确定^(OK)。请注意^(Notice)，您的对象会发生变化。

我们希望这篇文章可以帮助您改变工作簿的外观。

How to apply Themes and change the appearance on an Excel Workbook

In Excel, a Theme is a collection of default Colors, Fonts, and Effects that can be added to a workbook or items in a workbook, for instance, Tables and Charts. Each Theme gives a unique Color, Font, and Effects, which provides the document with a consistent professional look. When a new Theme is selected, the new style will replace any styles from the workbook.

The tools for creating Themes are available in the Page Layout tab in the Theme Group.  These tools are Themes, Colors, Font, and Effect.

• Themes: Themes give your workbook a consistent, attractive style
• Color: change the color in your document by clicking a color palette
• Font: Changes the text in your workbook by choosing a font set. It changes your document text at the same time.
• Effects: It changes the look of objects in the workbook. It uses Visual Effects.

Hovering over the Theme’s Tools in the Themes Group will give you a preview of how they will look on your worksheet.

In this tutorial, we will explain how to choose and customize your workbook in Excel.

How to Add Themes to your Excel Workbook

To add Themes to your workbook, ensure that the data is in a table and the style is normal because you will not see the Theme Palettes when selected applied to our worksheet.

First, go to the Page Layout tab on the top left of the Page Layout Window select Themes. In the Theme Group, a drop-down list will show select your desired Theme. When the Theme is selected, you will notice how the style and color change within the worksheet table.

You can also browse for a theme. Select Browse for Themes, your File Explorer window will pop up. Choose a Theme that you downloaded and add it to your table. Then OK. You can also save your Theme by selecting  Save Current Theme. The Theme will be saved to the File Explorer, name your Theme, choose the Folder you want your Theme to be in, then Save.

Add Theme Colors to your Workbook

Go to the Themes Group on the Page Layout tab and select Colors, a list of Color Palettes will appear, then select the Color Palette you want; notice only the colors within the table in the worksheet changes.

You can also customize your colors by selecting Customized Colors. A dialog box called Create New Theme Colors will appear; choose your Colors or Text/ Background Colors, then OK. The Theme within the table shown in the pictures will change.

Add Fonts to your Excel Workbook

Go to the Page Layout tab in the Theme Group. Select Fonts, Select your desired Font. Notice that the Font Style in the Table changes.

You can also customize your Font by clicking Customized Fonts. A dialog box will appear called Create New Theme Fonts. Click the drop-down arrow of the Heading and Body Font. You will see Fonts Styles you can download from the Microsoft Store. Select your desired style, then name your style, then OK.

Add Effects to your Workbook Object

In the Themes Group, select Effect on the Page Layout tab, a list of Effects will appear. Choose the  Effect you want, then OK. Notice that your object will change.

We hope this post helps you change the appearance of your workbook.

Related posts

• 如何修复损坏的Excel Workbook

• 如何在Excel中停止或关闭Workbook Sharing

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何在Microsoft Excel worksheet中添加Trendline

• 如何在Excel创建和使用Form Controls

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Excel中使用INT and LCM Functions

• 如何在Excel到Insert and Calculate Formulas和Functions

• 如何在Excel中使用Duration Financial Function

• 如何在Excel工作表中Freeze and Split Panes

• 如何在一页上打印Excel or Google Sheets中所选单元格

• 如何在Microsoft Excel中使用MID and MIDB function

• 如何在Excel中使用DISC function

• 如何在Microsoft Excel中添加或汇总Time

• 如何在Excel中计算列中的重复值

• Microsoft Excel正试图恢复您的信息

• 如何在Windows 11/10中创建Radar Chart