In this video, we're gonna talk about Styles, which are essentially
a prepackaged formatting collection that you can apply in different areas.
Now why this is important?
Is it actually allows you, if you set up your Styles in advance,
to very quickly update your workbook when somebody wants some changes things makes
life a lot easier.
So this is good groundwork that you can lay out
to make sure that your redevelopment is going to be simpler.
Now there are built in styles.
If I were to go in and say, let's go and grab the headers, I could
go to Cell Styles, and choose one of the title and headings styles at the top here.
So I could change this into, say, a Title at the top of my report.
And I know that everywhere in the workbook you use this title style
it will look exactly the same.
Where styles become more powerful though,
is where we actually start to create our own.
These areas here are data input cells.
I like to tell my users green means go.
So I always color my data entry cells in green.
I like to create a specific style for these.
So I'm gonna go to Cell Styles, and I'm gonna choose New Cell Style.
The first thing it asks me for is a name.
Right now, this one is called Style 1.
I'm gonna give it a name of DE_Values, so this is my data entries for values.
We have the option to change a few different things on the way here,
it says the number format.
I'm gonna leave a check box there, because I definitely want to control this.
I'm not happy with General, I'm gonna change it, but
I want to make sure that happens.
Alignment, sure, we'll leave that.
The Font, I'm not really worried about the size of the font in this particular case.
No matter what the size of the font is, I want to apply the rest of the rule.
Borders, don't care about that.
The Fill, definitely want that one, and the Protection status as well.
Let's go to Format, and see if we can control these.
We'll start with our Number format.
I'm gonna go and set this to an Accounting format with no symbols on the front and
with no decimals.
And the sample that I get is 25,000, that looks pretty good.
The Alignment, I'm not super worried about.
The Font, I'm not super worried about as well.
The Fill however, I wanna change this to be in a nice light green.
And the Protection status, I'm gonna set to unlocked.
And now when I say, OK, and I say, OK,
it actually creates the new style, but nothing really has changed.
And that's the trick here, is you need to come up,
find your new style under Custom, and click Apply.
And at that point, it will change for you.
And now I can say, hey, let's go in and
apply the same style to all of my data input cells.
Now you think, what's the big deal?
You could very easily go and you could change all these things to green, and
it would be super, super simple.
So why go to all the work of setting up a style?
And that's a valid point, but the thing is,
is that it's actually not about the initial setup, it's about the reuse.
Because then your boss comes along and says, I don't like that green.
I wanna see this in light blue.
Previously, you'd have to go and select every style in the workbook.
But for us now, right click will modify it.
We'll come back to our format, and we'll go back to the Fill tab,
and we'll say, which blue do you want?
I want this one right here.
Great, OK, and OK, and everything is done.
So styles are a great tool to allow you to lay the groundwork for
quick updates on things.
I like to use different styles for data entry values, for system, so
I can actually all make sure that things are indented property, and
have consistent headings and formats all the way through my document.
And that way if anybody ever comes back and ask me to change something,
it's a very quick update and boom, it goes all the way through the whole thing.
If I need to highlight cells that are user entry based boom, I can change it real
quick and have them all showing yellow for a little bit, and then switch them back.
So it's a very useful tool for
redevelopment in a hurry when you generally have little time.