Use themes to adjust worksheet colors, fonts, and effects

- This worksheet is unusual in that it has many many visual features. It's highly unlikely you would have all these together, but they do represent some of the things we work with in Excel, and we use Excel for presentation purposes at times, and we want some of these colors to be a bit more standardized, perhaps. And what if we're pulling together a project involving some PowerPoint presentations and also some Word documents? We might want to be using the same color scheme in all of these. Currently, I'm using what's called an Office theme. Not scheme, but theme. If you go to the page layout tab in the ribbon, off to the left you'll see a choice called Themes. And without reading all of this, pick a theme here to give your document instant style and just the right personality. You might want a consistent look and feel. The changes we make here will apply to the entire workbook, other worksheets as well within this workbook. And as we click the drop arrow here, lots of choices. 34 of them, at least initially, and as I'm dragging over these, and we don't have time to see them all, you see what's happening. We're changing the chart, we're changing some of the fonts in the numbers and columns E through H, that rectangle that we see, that beveled rectangle below the data is changing, so is the hexagon to the right in some cases, and also to organization chart off to the right. And one of these might grab your fancy. And notice how the changes are taking place. Now, what some people might do is pick one of these, because they maybe like most of what they see, but not necessarily all of it. I'm going to pick Frame here. I'm not sure this is my favorite, I'm not wild about that chart, about Damask. I know, back and forth here. Okay, we'll pic, Damask. All right, now we also have the option of changing just the colors. Just to the right of themes we see a drop arrow here. And sliding over these choices, we see the various options out there. There's a gray scale. Now, we're not changing the font here, we're changing the colors. So the text you're seeing in columns D through H isn't changing with regard to the actual font, but the colors are changing. So, we've got some other choices here, too. And just sliding up and down here. 23 different color choices. If we like the colors but we don't like the fonts, well we've got 25 choices here. The early ones don't seem to change much, but we can see a difference there with Ariel, with Corbel for sure, also Candara. And so the numbers, some go below the line, some above, and we've got some choices here as well too. Sliding over this one, that one, so on. You see what's happening to the numbers. The text not only in columns D through G but also on the chart as we slide up and down some of these choices here. And there's a third option out there, Effects. As we slide over this, notice this quickly changes the general look of objects. So this will not be affecting any of the text information or the chart, but keep an eye on the options here as we drag across some of these choices, 15 different ones here for the objects, that beveled rectangle, the hexagon and the organization chart as we slide over some of these. There's one called Grunge, and look at that beveled rectangle below the numbers. We've got all kinds of fine tuning opportunities here, and I think the general approach for a lot of people would be not necessarily to go to Effects and Fonts and Colors, but maybe to start with Themes. And although not the most important thing we do in Excel, I think at different times you'll say, hey, that's a lot more colorful than what I've been using, so let's switch to one of these. Maybe this one here. And of course we can always change these. Remember, it applies to all worksheets within the current workbook, and you could be using these exact same themes in PowerPoint files and in Word files.