Google Sheets Course: Basic Manipulations (3/4)
Horizontal Alignment
Now enter "100" in cell B14 and copy this value to cell C16:
Select cells B12 to C15:
To align to the left, click on the drop-down list then on the choice :
To center the text, click on the same drop-down list then on :
To align to the right, choose :
Vertical Alignment
Now enlarge the height of row 6:
Select cell B6 and center it vertically by clicking on the drop-down list then on the choice :
Then select cell C6 and align it vertically to the top by choosing :
Cell Merging
Merging allows to group several cells to make them into one.
Select the cells from A7 to C8 then click on the icon :
Since several cells contain data, a warning will remind you that in case of merging only the value of the upper left cell will be kept.
You then obtain:
Now select the cells from A9 to C11 then click on the drop-down list of merging and choose "Merge horizontally":
In this case, the cells are merged only horizontally:
The principle is the same for vertical merging.
Background Color
To change the background color of a cell click on then on the desired color.
Now apply the color "dark blue 2" to cell B6:
Text Color
To change the text color of this cell, click on and choose a color: