Themes in Excel

Excel allows you to change the overall look of your workbook with just one click.
This is called a Theme.

A theme includes:

• A set of colors
• Two fonts (one for headings, one for body text)
• Visual effects for shapes and SmartArt

When you change a theme, your entire workbook updates automatically.

---

Step 1: Check the Current Theme

1. Open your Excel workbook.
2. Click the Page Layout tab at the top.
3. Look at the Themes group on the left.

---

Step 2: See the Theme Colors and Fonts

1. Click the Home tab.
2. In the Font group:
   • Click the Font Color arrow to see the Theme Colors
   • Click the Font dropdown to see the Theme Fonts

👉 In the Office theme, the fonts are:

• Calibri Light (for headings)
• Calibri (for body text)

---

Step 3: Change the Theme (Example: Badge Theme)

1. Go back to the Page Layout tab.
2. In the Themes group, click Themes.
3. Click Badge.

✅ Your workbook now changes automatically:

• Colors update
• Fonts change
• Shapes and charts look different

---

Step 4: Check the New Colors and Fonts

1. Click the Home tab again.
2. In the Font group:
   • Open the Font Color list → you will see new theme colors
   • Open the Font list → you will see new fonts

👉 The Badge theme uses:

• Impact (headings)
• Gill Sans MT (body text)

---

Bonus: Create and Save Your Own Theme

You can make a theme that matches your style or company brand.

1. Go to Page Layout → Themes group
2. Click Colors → Customize Colors
3. Click Fonts → Customize Fonts
4. After customizing, click Themes → Save Current Theme

🎉 Your theme is now saved and can be used:

• In all Excel workbooks
• In Word and PowerPoint too