- [Lecturer] I have a slightly different file
than I used to.
Right now, I have units sold across the top of the sheet.
What I'd like to do, however, is put this unit sold right
in the center, so it looks a little tidier.
However, if I click on the cell
and click the center button, it's only going to align it
to cell A1, not the whole row.
What I can do in this case is merge these cells.
I'm going to click and drag and highlight cells A through F.
I want to line it up with the rest of the data.
On the home ribbon tab, I'll click merge and center.
It's going to combine everything and look very tidy.
Remember, we still click the center button.
At any time, I could left align it or right align it,
and it's going to change the alignment
to that entire merged area.
I can even change the borders and shading,
and it's going to change to all of those cells
that are merged.
If at any time I decide I don't want this anymore,
I can either click the button again to toggle it
or click the down arrow and choose unmerge cells.
It's going to put everything back the way it was
so that they're all unique individual cells.
and at any time, I can always do it again by clicking
and dragging and choosing merge and center.