1
00:00:00,05 --> 00:00:01,09
- [Lecturer] I have a slightly different file

2
00:00:01,09 --> 00:00:02,09
than I used to.

3
00:00:02,09 --> 00:00:06,06
Right now, I have units sold across the top of the sheet.

4
00:00:06,06 --> 00:00:10,00
What I'd like to do, however, is put this unit sold right

5
00:00:10,00 --> 00:00:12,09
in the center, so it looks a little tidier.

6
00:00:12,09 --> 00:00:15,00
However, if I click on the cell

7
00:00:15,00 --> 00:00:18,07
and click the center button, it's only going to align it

8
00:00:18,07 --> 00:00:21,08
to cell A1, not the whole row.

9
00:00:21,08 --> 00:00:25,05
What I can do in this case is merge these cells.

10
00:00:25,05 --> 00:00:29,09
I'm going to click and drag and highlight cells A through F.

11
00:00:29,09 --> 00:00:32,07
I want to line it up with the rest of the data.

12
00:00:32,07 --> 00:00:37,01
On the home ribbon tab, I'll click merge and center.

13
00:00:37,01 --> 00:00:40,04
It's going to combine everything and look very tidy.

14
00:00:40,04 --> 00:00:43,02
Remember, we still click the center button.

15
00:00:43,02 --> 00:00:46,05
At any time, I could left align it or right align it,

16
00:00:46,05 --> 00:00:48,03
and it's going to change the alignment

17
00:00:48,03 --> 00:00:51,03
to that entire merged area.

18
00:00:51,03 --> 00:00:54,01
I can even change the borders and shading,

19
00:00:54,01 --> 00:00:56,07
and it's going to change to all of those cells

20
00:00:56,07 --> 00:00:58,00
that are merged.

21
00:00:58,00 --> 00:01:01,07
If at any time I decide I don't want this anymore,

22
00:01:01,07 --> 00:01:04,04
I can either click the button again to toggle it

23
00:01:04,04 --> 00:01:08,08
or click the down arrow and choose unmerge cells.

24
00:01:08,08 --> 00:01:11,00
It's going to put everything back the way it was

25
00:01:11,00 --> 00:01:14,09
so that they're all unique individual cells.

26
00:01:14,09 --> 00:01:18,06
and at any time, I can always do it again by clicking

27
00:01:18,06 --> 00:01:23,00
and dragging and choosing merge and center.