Themes in Excel

Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Themes For Excel

Themes available in Excel are used in formatting the entire document or workbook. We can use the themes provided by Excel or customize them according to our choice. Themes are available in Excel in the “Page Layout” tab with the name of the “Themes” option. In addition, there are different options for colors and effects fonts.

Where are the Themes Stored in Excel?

The first question is, where are these themes hidden in Excel? The truth is that it is not hidden in Excel. Rather, it is visible just before us, but we have not recognized it for long.

Themes are available under “Page Layout” in Excel. So, for example, under “Themes,” we have themes, colors, fonts, and effects.

Themes option

Excel 2013 has as many as 31 built-in themes, 23 colors, and 15 different built-in effects.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Examples

Example #1 – Change Default Theme

Now, we will see the practical example of themes.

  1. But, first, we have created a basic default chart of sales for many years and one of the shapes.


    Themes Example 1

  2. These are the themes of the default theme of the office. To change the theme of these two: charts and shapes, go to “Page Layout.” The above available themes will preview the result before clicking on it.


    Themes Example 1-1

  3. In the above image, we selected the theme type “Facet.” Like this, we can choose any of the above themes, look at the preview, and finalize the theme.


    Themes Example 1-2

Example #2 – Change the Row Header & Column Header View

You must be familiar with the default row headerRow HeaderExcel Row Header is the grey column on the left side of column 1 in the worksheet that contains the numbers (1, 2, 3, etc.). To hide or reveal row and column headers, press ALT + W + V + H.read more and column header, which Microsoft gives, like the one below.

Themes Example 2

Step 1: Go to “Page Layout” and select “Fonts.”.

Themes Example 2-1

Step 2: Click on the dropdown and select “Customize Fonts.”

Themes Example 2-2

Step 3: Now, you will see below the new dialog box.

Themes Example 2-3

Step 4: Change the “Heading font” to “Harlow Solid Italic and the “Body font” to “Footlight MT Light.” Now, on the right-hand side, you can see the preview.

Themes Example 2-4

Step 5: You can name this font theme.

Themes Example 2-5

Now, look how row and column headers fonts have changed.

Example 2-6

It is slightly different from the default theme.

Example #3 – Create Your Own Theme Under Custom Theme

If you are not satisfied with the available wide variety of themes from Microsoft, you can create your theme and apply it to make a difference.

Usually, the theme is the makeup of three elements: colors, fonts, and effects. To design your theme, follow the below steps.

Step 1: Go to “Page Layout” and select “Colors.”

Themes Example 2-7

Step 2: Click on the colors drop-down list in excelDrop-down List In ExcelA drop-down list in excel is a pre-defined list of inputs that allows users to select an option.read more and select “Customize Colors.”

Themes Example 2-8

Step 3: Apply the colors below (you can give your colors), name your theme, and click on “Save.”

Example 3-2

Step 4: Now, click on “Fonts” and select “Customize Fonts.”

Themes Example 3-3

Step 5: Select the fonts as per your wish.

Note: We cannot change the font size. It will be, by default, 11 sizes.

Example 3-4

Step 6: Click on “Effects” and select any one of the existing effects. We cannot customize this. We have chosen one of the current effects.

Example 3-5

Now, we have created all theme options.

Step 7: Click on the “Theme” dropdown and select “Save Current Theme.”

Example 3-6

Step 8: Now, we will see a different save window. Please give them a name and select the “Save type” as “.thmx.

Example 3-7

Now, we have created our theme. When the Excel workbook opens, we can see this theme under Page Layout > Theme > Custom.

Example 3-8

Things to Remember

Recommended Articles

This article is a guide to Themes in Excel. Here, we discuss applying different themes in Excel with examples and downloadable Excel templates. You may learn more about Excel from the following articles: –