EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Themes in Excel
 

Themes in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 21, 2023

Themes in Excel

 

 

Themes in Excel

Themes in Excel are in-built and customizable functions to change the look of the workbook. There are several themes in Excel, and each theme has 12 colors, two fonts (including heading and body), and effects for shapes and SmartArt. The themes help it easy to make coordinate between colors, fonts, and graphics formatting so that they can be readily used and updated. Users can select a standard color theme through Excel themes, create their own color theme, change fonts, switch from one theme to another, save a custom theme for future use, and make various modifications to default themes.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Work with Themes in Excel?

From the page layout tab, the themes can be accessed. It can be seen that there are three parts, namely colors, fonts, and effects.

You can download this Themes Excel Template here – Themes Excel Template

Themes in Excel 1

We have created sample data in tabular format, raw format, and shape for applying themes. The following screenshot shows the same.

Themes in Excel 2

Changing the Colors

Step 1. There are several custom color schemes for the Excel theme. They can be selected from colors. Following is the screenshot.

Themes in Excel - Changing Colors Step 1

Step 2. Let us select an alternative color scheme; it will change according to the selection. Firstly, we have selected greyscale, and the color scheme has changed. In the following screenshot, we can see that the color scheme has changed for the data into consideration.

Themes in Excel -Changing Color Step 2

Step 3. We have used Orange-red as a color scheme, and we can see that the color scheme has changed.

Themes in Excel - Changing Color Step 3

Step 4. We can select our own customized theme. Select Create New Theme Colors. It is given in the screenshot below.

Step 4

Step 5. After selecting the new color theme, we can change the text background color and the color of accents and hyperlinks.

Step 5

After changing the color themes, the name can be changed and saved.

New Theme Color

Changing the Font

Like changing the themes’ colors, fonts can also be changed. The default font was Office Cambria Calibri. Now we have changed it to Office Classic Arial Times, New Roman.

Step 1. We did it by clicking the desired font from the font dropdown.

Changing Font Step 1

Step 2. We can also create a customized font. We have to click on Customize Fonts, and from the Create New Theme Fonts box, under the Heading font and Body font boxes, we have to pick the fonts we want.

changing font step 2

After selecting the heading font and body font, we click save.

New Theme Font

Changing the Effects

The font effects can also be changed. We can set the effects we want from the effects drop down from the page layout tab and effects dropdown.

changing effect step 1

The change will take place in the smart shape inserted in the data table.

changing effect step 2

The current themes can be saved from the theme dropdown.

Changing effects Step 3

Things to Remember About Themes in Excel

  • When a theme is applied, the change will occur to some previously made formats, such as font and fill colors.
  • There are other options in the themes group where there are options to change the individual component of a theme.

Recommended Articles

This has been a guide to Themes in Excel. Here we discussed How to work with Themes in Excel with examples and downloadable Excel templates. You may also look at these useful functions in Excel –

  1. Chart Wizard in Excel
  2. Excel Flowchart
  3. Interactive Chart in Excel
  4. Page Setup in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Themes Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Themes Excel Template

EDUCBA

डाउनलोड Themes Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW