A more recent version of the Excel course is available here: Excel Course

Excel Course: The Basics (alignment, merging cells, colors)

Alignment

Select cells B11 to C14.


select cells excel basics3

To align to the left, click on "Align Text Left":

text left excel basics3

To center, click on "Center":

text center excel basics3

To align to the right, click on "Align Text Right":

text right excel basics3

Now increase the height of row 5.

edit row height excel basics3

And edit the vertical alignment (see red area) of row 5's cells so that you get this result:

vertical alignment excel basics3

Merging Cells

Merging cells allows you to make one cell out of several.

Select cells A6 to C7:

select excel basics3

Click on the button shown below to merge the cells:

merge cells excel basics3

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:

merged cell excel basics3

Cell Background Color

Click on a cell, then click on the "Fill Color" button and choose a color:

cell background color excel basics3

Font Color

Select a cell, then click on the "Font Color" button and choose a color.

cell text color excel basics3