- [Instructor] Let's work with borders
and background colors for this sheet.
If you're following along,
it's in the Exercise File titled Borders in Chapter 2.
Now, we already have some background colors
here for these cells,
but I want to make the actual units sold
stand out a little bit more.
So I'm going to click and drag
to highlight all of this data.
And now from the Home ribbon tab,
I'm going to click the down arrow next to the paint can.
This is going to change the fill color.
I can hover my mouse over all of the choices
and it's going to change to give me a preview
of what it's going to look like.
I can also choose more colors down here.
I can choose from any color in this palette,
or I can click Custom
and put in the RGB or hex value
if I need to match something specific
like my company's logo.
I'll click Cancel.
I'll choose a color
and then to see it,
I do need to click away
because right now the cells are highlighted,
so they're a completely different color.
Here it is.
Something else that I might want to do
is underline certain text
or cells to make them stand out a little bit more.
Let's take this Units Sold cell.
I'm going to click the down arrow next to the border icon,
and here's where I can choose
what kind of cell border I want.
For example, just a bottom border or all borders.
And if I have multiple cells selected,
it's going to apply to all of those cells.
I can even draw a border
and change the color if I wanted to
to make it stand out.
In this case, I'm going to choose a thick bottom border.
And like before, I can't see the border,
but it's there.
As soon as I click away, I'll be able to see it.
In fact, I can click and drag
across all of these header cells
and click this button again
to apply that thick bottom border to those cells also.
Something else that we can do,
maybe once this is all done
and we want to make it look a little bit cleaner
to email it out to somebody,
we can get rid of all of these gridlines that you can see.
I'm going to change to the Page Layout ribbon tab.
All the way in the middle of the screen,
I can find where it says Gridlines,
and if I uncheck View,
all of those lines go away
and I'm left with a white background.
Now I could change that background if I wanted to.
In fact, I can also change the theme of all of these cells.
While we're still in this Page Layout tab,
all the way on the left-hand side,
here's where I can change the theme of the sheet.
If I click the down arrow next to Themes,
I can hover my mouse over all of these themes
and you can see the font
and the colors changing
as I'm hovering my mouse over all of these themes.
These changes aren't being applied,
they're just being previewed.
The last thing I might want to do
if I'm sending this out
is maybe brand or watermark this with my company's logo.
This time I'm going to change to the Insert ribbon tab.
There's a lot of things that we can insert here,
such as charts and maps and pivot tables,
and we'll be talking about all of those,
but right now I'm interested in pictures.
I'll click Pictures
and I'll place it over the cells.
I don't want it to fit inside of a cell,
and I'm going to choose to insert a picture from this device
because the picture is a logo file that's on my computer.
It's going to bring me to the Browse screen.
I'll browse to the Exercise Files
and find our logo and click Insert.
It's going to dump it in just as it is.
And like across all Office products,
to resize it, I can click and drag with my mouse
and move it around anywhere in the file.
So the first thing I might want to do is make it smaller,
and you'll see here how I can place it right over the cells.
That's because we told it to place it over the cells.
I'll put it in a spot that I think makes it look nice.
And here's our finished sheet.
If I want to put those grid lines back,
don't forget that we got there
by changing to the Page Layout tab,
going to the Gridlines area,
and this time to put them back,
I'm going to place a check mark next to View.
It has no bearing on my image.
As you can see, the gridlines aren't over the image,
they're under the image,
so they're not going to get in the way there.
But now it looks a lot more polished
with those borders and shading.