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
Download PDF files of this course