Cell styles allow us to apply a number of formatting items all in one go, and Excel provides and allows us to create these predefined styles. Let's say I'm looking at these headings and I wanna change them so they stand out a bit more. I select them, go up to the home ribbon and then click on cell styles. You get the cell styles provided in that document. If you're doing this in a document that's already been used by somebody else, you may have their cell styles. Here are ours. If I had opened this up in a blank document in Excel and brought in some data like this one, if I go to the cell styles here, I can see the Windows standard Excel cell styles provided to me. Let's carry on using these ones, but if you don't have these, don't worry. It's just an example.

I'd like to change the headings to heading for cell style. So I select the headings, go to cell styles, and then select heading 4 that has now been applied. And I can see the color has changed to a dark blue and the text is bold. I'm now going to apply that to a few more places. So maybe it's the workout one heading, and maybe I select column C and apply that same cell style there.

Imagine now my boss comes to me and says, Hey, I don't want dark blue. I want a very light blue. If I hadn't used cell styles, I would be thinking, oh no, I need to go in and change each of these cells individually.

That's not the case with cell styles. Instead, we can go up to the cell styles again, go to heading four, right click and select Modify. I can now change the attributes that heading four has.

At the moment. It says that just the font is going to be changed, and that's okay. So I don't change anything here. I come up to format, and I can see it is Calibri bold size 11, and the dark blue color. I want to change that to light blue. So I click the dropdown, find the color I want, and click okay. Now, the great thing is when I click okay, A second time, this new light blue color will be applied to all the cells that have been formatted in this style. So that has saved me from manually having to go in and change all of the dark blue to this light blue color. So very quick, very easy to change things using cell styles.

You can create your own cell styles as well. If you go to cell styles, click on the dropdown, go down to the very bottom and select new cell style. It'll ask, what do I want to do? The default for any cell is to use the normal cell style. So if you tick these boxes, you'll be overriding the normal style. In this example, let's just create a new cell style that will make something bold, the font size a bit bigger and will change the color. That's all in font, so I will untick everything else and then click on format.

Currently, I see it's Collibra. I'm gonna leave it at that, but let's change it from regular to bold. Let's make it size 14, and I'll change the color to red. I click okay. Okay, again, and I have a new style. Let's now use it. If I select the items in column D, I go to cell styles. I didn't specifically name my style, but I can see here style one is the one I just created. I click okay, and that has now been applied. If I want to take these back to the normal cell style, I click on the dropdown next to cell styles and select normal, and that's done.