Video: Apply themes to change the look of a workbook

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Discover more Excel training at LinkedIn Learning

Use or customize a theme in your Excel workbook to make your data stand out.

  1. Select Page Layout > Themes.

  2. Select a theme you want to use from the available list.

    Note: You will see theme previews in your worksheet as you hover over different themes.

Want more?

Discover more courses like this at LinkedIn Learning

Change the appearance of your worksheet

Now we also have something called themes.

I'm going to go to a different worksheet here called Themes.

This worksheet has an object it in, this hexagon in the lower right, it's got an object here with some text on it, it's got some other data that's been highlighted and it's got a chart.

We can see all of these.

If you're working on a project that might involve Microsoft Word and/or Microsoft Project, if you're pulling together some material possibly for publication or for presentation, it would make sense to be using the same color palettes in all of those.

So the idea of a theme was introduced by Microsoft in Excel 2007, PowerPoint 2007 and so on, can be applied the same way in all three software packages.

We find this on the Layout tab.

Now I don't change themes for myself very often.

But when I do, I go to this button right here.

Themes, pick a new theme to give your document instant style and just the right personality.

Each theme uses a unique set of colors, fonts and effects to create a consistent look and feel.

So they're themes, the standard theme that most people use and some people never change is Office.

There's one called Facet and as I'm sliding over these, look what's happening to the right, Ion, Slice, how many choices do we have here?

How much time do you have?

You can begin to see the different effects of what's happening here, this is workbook wide.

We're not looking at the other sheet, but changes will occur there too when we finally lock in and decide on one of these.

Suppose this one appeals to us, Celestial.

And we can change it if we don't like it.

Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at

Enjoy one month of free access to LinkedIn Learning

Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.


  • Get unlimited access to over 4,000 video courses.

  • Receive personal recommendations based on your LinkedIn profile.

  • Stream courses from your computer or mobile device.

  • Take courses for every level – beginner to advanced.

  • Practice while you learn with quizzes, exercise files, and coding windows.

  • Choose a plan for yourself or your entire team.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.