قالب وردپرس درنا توس
Home / Tips and Tricks / How to Save Time on Excel Topics

How to Save Time on Excel Topics



  Excel logo

An Excel theme is a collection of colors, fonts, and effects that you can apply to a workbook in a few clicks. Designs ensure a consistent and professional look and feel of your reports, and make it easier to comply with corporate brand and identity policies.

Applying an Excel Theme

You can find the themes on the Page Layout tab of Excel.

  Topics on the

tab You can select a topic for your workbook that will apply the collection of colors, fonts, and shape effects.

  The selection of built-in themes

Or You can also select only a specific color or font theme for the application.

  Choosing Color Schemes

Excel includes many built-in themes (as well as color and font themes) that you can apply to a workbook to enhance and save the visual impact. You must try to manually select colors and fonts that fit together well.

The following image shows the blue-green color scheme applied to a workbook. Both diagrams adopt the color theme and maintain a consistent appearance.

 An applied blue-green theme and its effects on charts

How to Create a Custom Theme

That's great! However, the ability to create a custom theme is exactly what you need.

Creating a Custom Color Theme

Click the Colors list in the Themes group and click Customize Colors at the bottom of the list. [19659011]   Create your own color theme

This will open the Create New Theme Colors window.

Enter a name for your new color theme. In this example, I'll create a color scheme for the marketing team.

Next, select the colors you want for this topic from the lists and click Save when you're done.

 Adjusting Colors in a Color Theme

This color theme is then available in the list of options that can be applied to the workbook.

The following picture shows the applied topic and its effects on the diagrams and also on the cells behind the list.

 Custom Color Scheme Applied to a Workbook

The theme applied also affects the options you receive when applying colors to other sections of Excel. For example, you can see the color picker that is now available when applying a fill color.

 Apply a fill color from the theme

The options are variations of the colors that I selected in the marketing topic. [19659015] Creating a Custom Font Design

Click the Font button, and then click Customize Font.

 Creating a New Custom Font Design

The Edit Font Design window opens. [19659011] Enter a name for your font design and select from the lists the fonts you want to use for the "headings" and "text font". Click on "Save".

 Customizing a Font Theme

This font theme is then available in the Fonts list and is applied to the workbook below.

 Typeface applied to a workbook

The Effect Design

The Effect Design is a selection of shadows, reflections, lines, and other effects that can be applied to shapes.

You can not customize these themes, but you can choose one from the list available through the Effects button.

 Effects Theme Selection

Saving Your Custom Theme

You can use the custom color and font themes that were created and applied to save them to a topic.

Click the Themes button and then click Save Current Theme.

 Save Current Topic

The Save Current Topic window opens. A theme is a THMX file and can be saved like an Excel workbook.

Enter a file name for the theme.

The default location is in the template folder. Excel automatically searches for the topics here. It is therefore recommended to save them here. You can, however, save a topic anywhere. Click on "Save".

 Saving the Current Theme in the Template Folder

You can now apply the theme to any workbook using the Themes button.

 Choosing Your Custom Settings Gallery Theme

If you saved the topic to a location other than the template folder, click Search for Topics to locate it.

Click a button to display all colors and fonts, and effects are applied to the workbook. This can save hours of formatting time.


Source link