Excel Course: The Basics (alignment, merging cells, colors)
Select cells B11 to C14.
To align to the left, click on "Align Text Left":
To center, click on "Center":
To align to the right, click on "Align Text Right":
Now increase the height of row 5.
And edit the vertical alignment (see red area) of row 5's cells so that you get this result:
Merging cells allows you to make one cell out of several.
Select cells A6 to C7:
Click on the button shown below to merge the cells:
Warning: Only the value of the upper left hand cell will be preserved when more than one of the cells contains data !
This will be the result:
Cell Background Color
Click on a cell, then click on the "Fill Color" button and choose a color:
Select a cell, then click on the "Font Color" button and choose a color.