- [Instructor] There are no rules
when it comes to formatting the way an Excel spreadsheet
is going to look.
It depends on what type of data it is, who it's for,
especially how much time you have
to invest in formatting it.
There's so many reasons.
Let's take this specific sheet for example.
And this one's pretty basic.
It's got some columns of data and a border at the top
so that you can see these column headers more clearly.
We can go to this one and this is a little more complex.
This one's an actual financial balance sheet,
but you'll see that you can have extensive formatting.
The text is different, there's different colors,
there's different borders,
there's even an image in here.
Spreadsheets can go all the way to the end
so that you may have to scroll horizontally
as well as vertically.
There's so many different types.
I'm going to open up the last sheet that I was working on.
This one's in your exercise files.
We can format this so it's easier to read.
For example, these years, these are our column headers.
We can make these stand out a little bit more.
Now we could always click directly into one cell,
and from the Home tab, I can change anything.
I can make it boldfaced or change the font.
I can change the background color,
even the color of the text.
If I wanted to, I can highlight all of these cells
and make the same changes all at once.
I'll click the down arrow next to the paint can
and choose a background color.
Now, this has made the text too hard to read,
so I can even change the font color by doing the same thing.
That stands out a little bit more.
We can do the same thing with the rows.
In fact,
if I wanted to select this entire rows worth of data
and change it all at once,
I can click on the entire column header
to select everything.
Now I can make these all boldfaced.
Now this is unit sold, the title of the entire spreadsheet,
we might want to make this stand out even more.
If I make the font bigger in just this one cell,
I do want to show you that this is what's going to happen
to the rest of the cells in the row.
It's going to make these bigger too
and there's nothing that you can do about that.
Now we can also change
the background color of this individual cell.
Starting to look a little bit more formatted.
Now because I made this font a little bit bigger,
these cells aren't exactly centered,
but we can fix that.
I'm going to highlight all of these cells
and I'll click the center align button.
It's going to center align them in the cell,
and in fact,
I can even middle align them so it's centered
between the top and the bottom of the cell itself.
Now that looks much nicer.