1
00:00:00,05 --> 00:00:01,08
- [Instructor] There are no rules

2
00:00:01,08 --> 00:00:04,02
when it comes to formatting the way an Excel spreadsheet

3
00:00:04,02 --> 00:00:05,06
is going to look.

4
00:00:05,06 --> 00:00:09,02
It depends on what type of data it is, who it's for,

5
00:00:09,02 --> 00:00:10,08
especially how much time you have

6
00:00:10,08 --> 00:00:12,06
to invest in formatting it.

7
00:00:12,06 --> 00:00:14,03
There's so many reasons.

8
00:00:14,03 --> 00:00:16,08
Let's take this specific sheet for example.

9
00:00:16,08 --> 00:00:18,05
And this one's pretty basic.

10
00:00:18,05 --> 00:00:21,05
It's got some columns of data and a border at the top

11
00:00:21,05 --> 00:00:25,02
so that you can see these column headers more clearly.

12
00:00:25,02 --> 00:00:28,05
We can go to this one and this is a little more complex.

13
00:00:28,05 --> 00:00:31,00
This one's an actual financial balance sheet,

14
00:00:31,00 --> 00:00:34,02
but you'll see that you can have extensive formatting.

15
00:00:34,02 --> 00:00:37,03
The text is different, there's different colors,

16
00:00:37,03 --> 00:00:38,06
there's different borders,

17
00:00:38,06 --> 00:00:40,07
there's even an image in here.

18
00:00:40,07 --> 00:00:43,03
Spreadsheets can go all the way to the end

19
00:00:43,03 --> 00:00:45,03
so that you may have to scroll horizontally

20
00:00:45,03 --> 00:00:46,09
as well as vertically.

21
00:00:46,09 --> 00:00:49,03
There's so many different types.

22
00:00:49,03 --> 00:00:52,06
I'm going to open up the last sheet that I was working on.

23
00:00:52,06 --> 00:00:54,05
This one's in your exercise files.

24
00:00:54,05 --> 00:00:58,00
We can format this so it's easier to read.

25
00:00:58,00 --> 00:01:02,01
For example, these years, these are our column headers.

26
00:01:02,01 --> 00:01:05,00
We can make these stand out a little bit more.

27
00:01:05,00 --> 00:01:07,05
Now we could always click directly into one cell,

28
00:01:07,05 --> 00:01:10,05
and from the Home tab, I can change anything.

29
00:01:10,05 --> 00:01:14,09
I can make it boldfaced or change the font.

30
00:01:14,09 --> 00:01:16,04
I can change the background color,

31
00:01:16,04 --> 00:01:18,05
even the color of the text.

32
00:01:18,05 --> 00:01:21,08
If I wanted to, I can highlight all of these cells

33
00:01:21,08 --> 00:01:26,07
and make the same changes all at once.

34
00:01:26,07 --> 00:01:28,09
I'll click the down arrow next to the paint can

35
00:01:28,09 --> 00:01:32,03
and choose a background color.

36
00:01:32,03 --> 00:01:34,08
Now, this has made the text too hard to read,

37
00:01:34,08 --> 00:01:40,07
so I can even change the font color by doing the same thing.

38
00:01:40,07 --> 00:01:42,07
That stands out a little bit more.

39
00:01:42,07 --> 00:01:45,00
We can do the same thing with the rows.

40
00:01:45,00 --> 00:01:45,08
In fact,

41
00:01:45,08 --> 00:01:48,02
if I wanted to select this entire rows worth of data

42
00:01:48,02 --> 00:01:50,00
and change it all at once,

43
00:01:50,00 --> 00:01:52,00
I can click on the entire column header

44
00:01:52,00 --> 00:01:53,07
to select everything.

45
00:01:53,07 --> 00:01:57,04
Now I can make these all boldfaced.

46
00:01:57,04 --> 00:02:01,02
Now this is unit sold, the title of the entire spreadsheet,

47
00:02:01,02 --> 00:02:03,09
we might want to make this stand out even more.

48
00:02:03,09 --> 00:02:09,01
If I make the font bigger in just this one cell,

49
00:02:09,01 --> 00:02:11,07
I do want to show you that this is what's going to happen

50
00:02:11,07 --> 00:02:13,06
to the rest of the cells in the row.

51
00:02:13,06 --> 00:02:15,01
It's going to make these bigger too

52
00:02:15,01 --> 00:02:17,07
and there's nothing that you can do about that.

53
00:02:17,07 --> 00:02:18,07
Now we can also change

54
00:02:18,07 --> 00:02:22,08
the background color of this individual cell.

55
00:02:22,08 --> 00:02:25,05
Starting to look a little bit more formatted.

56
00:02:25,05 --> 00:02:28,02
Now because I made this font a little bit bigger,

57
00:02:28,02 --> 00:02:30,04
these cells aren't exactly centered,

58
00:02:30,04 --> 00:02:32,00
but we can fix that.

59
00:02:32,00 --> 00:02:34,05
I'm going to highlight all of these cells

60
00:02:34,05 --> 00:02:37,06
and I'll click the center align button.

61
00:02:37,06 --> 00:02:39,06
It's going to center align them in the cell,

62
00:02:39,06 --> 00:02:40,05
and in fact,

63
00:02:40,05 --> 00:02:43,00
I can even middle align them so it's centered

64
00:02:43,00 --> 00:02:45,08
between the top and the bottom of the cell itself.

65
00:02:45,08 --> 00:02:48,00
Now that looks much nicer.