In this video, I want to show you how a little bit of pre-planning and foresight
can actually help make updates to the styles of your workbook very, very easy.
So typically, what we do, and we're building something,
is we'll grab a set of rows for our header here.
And we'll increase the font size, and change the bold, set the color,
and all those kind of things.
And we do it all manually.
So when you get to another worksheet, you've gotta do the same thing again.
And after you've got 50 worksheets,
there's bound to be a couple that have an inconsistent style heading.
Put that in front of an accountant and
they lose their mind because they value consistency.
And this is what the Styles Gallery is all about,
is promoting consistency through your workbook.
So in this case, if I have a report title, for example, I could go and
choose the Title style.
And if I apply that consistently on every single workbook,
everything will be the same on every single worksheet,
because it's a predefined package that gets applied to the cells.
And if it's ever modified or
updated, it rolls through every single cell that has that style.
We also know that we can do number formatting using things like comma styles,
for example, to go and actually assign this block.
But this actually starts to show the problem that we have when our stuff has
been applied willy-nilly and ad hoc.
Notice that these data entry cells have this format, these ones do not.
But how do I roll it through to make it consistent without having to go and
apply it to each block of cells?
So let me just undo this and show you how I like to take care of this.
Now, Microsoft has provided some built-in styles for data.
So we've got an input cell here that would make it look like this nice lovely orange
here, not my favorite.
So what I'm going to do is I'm going to build my own input cell,
because in actual fact, when I'm building things,
I usually create multiple styles for what we actually have here.
I'm going to create one called DE, for data entry, underscore values.
And I'll typically create one for values, dates, and text.
And if I've got different numeric styles, I might have values underscore decimal
zero underscore decimal two or something like that.
Notice that it's picked up, that there's consistency amongst the cells but
not the border.
This one here has a bottom border.
So it says, well, I don't know what you want to do with that.
If you'd like to force a border on everything, we can do that,
but I'm going to leave it alone.
It says, your font is this, your alignment is general.
Okay, no problem, your number format is general.
Yeah, that's great, but you know what?
I don't really want that to be a general number format.
So I'm going to go to click on Format > Number,
I'm going to choose Accounting with no symbol and 0 decimal places.
Will say, OK, and what I'm going to do at this point in time is I'm going to say,
all right, let's accept this.
So, this cell style that I'm building is going to have my comma style with
zero decimals.
It's going to be a line general on the bottom.
It's going to use this specific font, it will not influence borders at all.
So if there's a border on the cell, it will leave it there.
If there's not a border, it will not add one.
It will put in the fill color that I have selected, blue, and
it will lock the cell from a protection standpoint.
If I go and say, OK, at this point, you'll notice nothing happens.
Why?
Well, because we just created the style, we now need to apply it.
And when we do, it looks like this, okay?
Well, but you still have to go through and apply it to every block.
So have I really saved myself any effort?
And the answer on this one is not during the setup, as a matter of fact,
that cost you time.
But check this out.
I now want to deploy this as an input template to somebody.
I'm going to go right-click on the style, and
I'm going to modify it because I realize that there's something I need to do.
I need to make sure that the protection is changed, and
I actually want the color to be different.
So I'm going to go to Format, and Fill, and change the color to light green.
In my workbooks, green means go.
If it's green, you can put data in.
I'm also going to go to the Protection tab, and
I'm going to unlock these particular cells.
I'm going to say, OK, and OK.
You'll notice that all of them change to green immediately.
And if I go and right click, and go to Format Cells on this one, and
go to the Protection tab, you'll notice that it is now unlocked as well.
And this is where that pre-setup and thinking about things in advance makes it
very easy to deploy consistent changes throughout your entire workbook very,
very quickly.