Alignment lets you specify how values are placed within a cell.

Right now the values in our spreadsheet are vertically aligned to the bottom of the cells. To change the spreadsheet so that the values align to the top of the cells use the alignment function.

First, select all the cells to align. In this case we’ll choose all cells by clicking on the upper left corner of the spreadsheet. Next, right click one of the cells and select format cells from the popup menu.

The alignments options are found on the alignment tab of the format cells screen.

Horizontal alignment settings determine whether an item will align to the left, right or center of a cell. Vertical alignment will let you specify whether items align to the top, middle, or bottom of a cell.

Select the top option from the vertical alignment dropdown and click the OK button. Now the values in our worksheet all align to the top of the cells.

There are 4 buttons on the default toolbar that will let you change the horizontal alignment of a cell to align to the left, right, center or justify the text. To use these buttons, just select the items you want to align and click on the desired alignment button.