- [Instructor] So our objective is to style this table
without changing any of the individual styles.
So we're going to style it as a whole
because your table could have 30 rows.
It could have a thousand columns.
You need a easy and a fast way to do this.
There's two different ways that we're going to go over.
The first one is built into Sheets.
So it's nice and simple.
You go to "Format"
"Alternating colors,"
so it doesn't say, "Table styling."
It just says, "Alternating colors."
And a few things to look at here
is that because I already had this area highlighted
the "Apply to range" is filled out.
You could modify that here if you need to.
What you'll notice, I'm going all the way down to row 15,
but 15 is a footer.
So we need to indicate that
because the footer will be styled a little bit differently
and then you just choose the color.
Right?
So it's pretty easy.
There's no differentiation of the columns.
It does help the header and the footer stand out.
When you press done, we'll move off
to the side here to look at it.
This table's already a little bit easier to look at.
That's all you want to do.
Then you're done at this point.
But if you want to take it kind of to the next level
if you will,
there is an extension available.
So this is made by a company called Ablebits.
It's been a long-time supporter of this channel.
And if you want to get your own copy of this add-in
so you can follow along and try out what I'm doing.
Please get it from the affiliate link in the description.
Getting it from there will help to support my channel.
Let's just put this active cell anywhere in this table.
And the first thing that it's doing
is it's offering different styles and you can see
that these are differentiating in the columns if you want
and they have different color pallets.
They're separated in the different categories.
We can even go so far as to make them Juicy
if you'd like.
Let's do that. We'll look at the Juicy ones.
And before we apply one of these, though,
we will make sure that the header row and footer row
in our case is checked, because we do have both.
We want alternating colors
and we will keep on the left and the right column,
just so you can see that
and we'll left click on "Style".
All right, there we go.
So it changed the font.
It even made the headers bold
which is an improvement over the built-in table styling.
Differentiated the leftmost and the rightmost columns,
by making those bold
and then stopping the alternating row formatting.
So these are a lot of fun.
Let's choose one more,
take a look at that.
And then we'll look at some options.
We don't wanna do Practical, do we?
No, let's do Contrasting.
See if we can get something that kind of screams at us.
(instructor laughs)
Oh man.
Okay, there we go.
Let's just that so we don't have to look at it.
We'll style one more.
All right. That's better.
Now some customization options in here.
One, you can turn on or off some of the attributes
of this styling by using this control
that looks like a filter.
So let's say we wanted to do it
but we didn't want to change a font.
So I've customized what it's going to do.
You see the filter turned red.
I'm going to change the font back, Arial.
And when I style it, this time,
thinks about it for a while,
does everything it did before
but it left the font as Arial.
Right, so it's highly customizable
and if you want to dig down even deeper,
you left click on this drop down
and you can change the style per column
it's left and the right column
just the headers or just the body.
You have all of the styling options right here.
So if you can think of a particular style you want
you'll be able to apply it here.
Let's just take the body and do the "Alternating color."
Let's make it pretty loud. Let's do red.
And what we'll "Save as"
and we will say,
"Red and Aqua."
We'll call that color Aqua.
Save and we'll style it.
Boom, there we go.
Ablebits' most popular plugin is called Power Tools.
Next up we'll show you how to use this plugin
to manage your different sheets in your spreadsheet.
Thanks for watching.
It's nice to have you along.