Not everyone is a talented graphic designer. I'm certainly not. To help us out, the Office team defined themes, which are collections of colors and fonts we can use to make sure our documents have a coordinated color palette. Office themes have replaced the old AutoFormat feature, which resets a formatting that you can apply to your worksheets. The idea is that each Office theme has a set of colors and fonts that work well together. To apply an Office theme to an existing worksheet, you go to the Home tab of the Ribbon, and then, here in the Themes group, click Themes and then select the theme that you want to apply.
The default theme, the one that Excel applies normally, is called Office, and I'll just select another one, I'll call it Advantage, and when I do, you'll see that several things changed. First, the fonts changed, both here in the body of the worksheet and also for my headings, and also you'll see that the color scheme changed. Instead of having blue underlines, I now have purple here and here, and also the text is a bit more purplish as well. If you apply a theme and decide that you don't want to have it applied anymore, you can either go back to the Themes gallery and just select another one, or you can press Command+Z, and that will undo the operation.
A theme's colors are divided into two categories. First, you have the Standard Colors, which don't change, and the Theme Colors, which will, if you change your theme. So, for example, let's go ahead and change the fill color for the cell, and I will change it to one of the Theme Colors, and I will select a light red. When I do, Excel fills the cell with that color, but now, if I change the theme to call it Austin, Excel changes the color here. It also changed the underline, and it changed the font, and in this case the font size.
I'll press Command+Z again to undo those last two changes. If I were to change the cell's fill color to one of the standard colors by clicking the down arrow next to the fill color button and then filling it with yellow, now if I change the theme to Civic, nothing happens to the cell. That's because I selected a Standard Color, and it will not change, even if everything else around it does. I'll press Command+Z to undo those last two changes, so my formatting is back to where I started, and what I'll do now is instead of applying a theme entirely, what I will do is I will just select a theme's colors.
Let's say that I want to apply the colors from the Angles Office theme. When I click it, Excel applies the colors. It's kind of subtle, but you'll see that up here, we changed from blue to a slight gray, and I can also change the fonts separately. So, if I go over here to the Themes group on the Home tab and click the Fonts button, I can select a new set of fonts, and in this case, I will change to a combination of Arial for headings and Times New Roman for the data. So, I've combined this color scheme with these fonts, and together they make up a theme.
So if I wanted to, I could save this combination as a new theme. To do that, you click the Themes button and click Save Theme. When you create a theme, Excel saves it as a file, so you can apply it not only to your Excel documents, but also to your Word and PowerPoint documents as well. So, in this case, I will save it as Office2 and press Return to save it. Now, if I click the Themes button to display the Themes gallery, my theme, Office2 appears at the top.
Office themes help you design worksheets with colors and fonts that work well together. If you prefer, you can mix and match the existing color and font sets to create a theme of your own design.
Author
Released
10/26/2010- Customizing the Ribbon
- Formatting worksheets, cells, and cell data
- Sorting and filtering data
- Working with formulas
- Detecting formula errors
- Creating charts
- Importing data
- Inserting objects and graphics
- Using PivotTables
- Recording macros
- Sharing workbooks
Skill Level Beginner
Duration
Views
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.
Related Courses
-
Introduction
-
Welcome1m 12s
-
-
1. Getting Started with Excel
-
Customizing the Ribbon4m 20s
-
Setting program preferences3m 20s
-
Getting help in Excel4m 16s
-
2. Managing Workbooks
-
Setting workbook properties4m 14s
-
3. Managing Worksheets, Cells, and Cell Data
-
Creating an Excel table4m 43s
-
Sorting worksheet data3m 2s
-
Creating a custom sort order3m 54s
-
Filtering worksheet data4m 6s
-
Managing worksheets5m 28s
-
4. Summarizing Data Using Formulas and Functions
-
Adding a formula to a cell3m 59s
-
Creating an AutoSum formula3m 22s
-
Managing scenarios4m 59s
-
5. Formatting Worksheet Elements
-
Managing text alignment3m 56s
-
Copying cell formats4m 2s
-
Managing cell styles3m 16s
-
Managing Office themes3m 31s
-
6. Working with Charts
-
Creating pie charts2m 32s
-
Creating line charts4m 34s
-
Creating XY (scatter) charts1m 49s
-
Creating stock charts4m 11s
-
Adding trendlines to charts4m 14s
-
Creating sparkline charts4m 31s
-
7. Working with External Data
-
Using hyperlinks6m 1s
-
8. Working with Objects
-
Adding and adjusting images5m 38s
-
Creating WordArt2m 34s
-
9. Exploring PivotTable Reports
-
Creating a PivotTable report4m 37s
-
Pivoting a PivotTable report3m 17s
-
Applying a PivotTable style2m 20s
-
Creating and editing styles2m 59s
-
10. Reviewing and Sharing Your Spreadsheets
-
Checking spelling3m 32s
-
Managing workbook comments3m 40s
-
Exporting to other formats1m 33s
-
Protecting a workbook2m 36s
-
-
11. Automating Workbooks Using Macros
-
Running an existing macro4m 56s
-
Recording a macro3m 56s
-
Adding comments to a macro2m 43s
-
-
Conclusion
-
Additional resources1m 1s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Managing Office themes