• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Save Themes in Excel

July 30, 2021 by Andrew Childress
Save themes in Excel

Themes in Excel consist of custom colors, fonts and style options that you select. Let’s learn how to save themes in Microsoft Excel.

Themes in Excel consist of custom colors, fonts and style options that you select. Often, you may find yourself wanting to use these themes over and over again. Fortunately, there’s an easy way to save them. Let’s learn how to save themes in Microsoft Excel.

How to Save Themes in Excel

Let’s imagine that you have a theme in Excel, and you want to share it with others. Or, you want to use it again and again without making choices like color selections from scratch. There’s a quick way to do this that saves you time and hard work.

To save themes in Excel, begin by going to the Page Layout tab. You’ll find this on Excel’s ribbon, between the Insert and Formulas tabs. Click on it.

Over on the far left side, you’ll see the Themes dropdown. Here, you can select from the default Excel themes, or browse for more designs online. Once you have a theme built, you can then save it in Excel.

Save themes in Excel

Still working in the Themes dropdown, click on Save Current Theme at the bottom. Excel will launch the Save Current Theme menu. Here, you can name your theme file in the Save As box. By default, Excel will store the theme in the Themes folder. When you’re finished, click Save.

Save Excel themes

From here, you have two options. You can browse to the Themes folder on your computer, then share your custom saved theme with others via email or a file-sharing app like Microsoft OneDrive.

You’ll also find that your custom theme is available for your own use. When you click on the Themes dropdown again, you’ll see that the theme appears in the newly-created Custom section.

Save custom Excel themes

Clicking on it will immediately open the theme in Excel, ready to use and customize again and again.

As you can see, it’s easy to save themes in Excel.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:How to show the top percents of your data in ExcelHow to Show the Top Percents Of Your Data in Excel
Next Post:Add Text Box in ExcelInsert text box in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top