The Alignment Group

Contact Us or call 1-877-932-8228
The Alignment Group

The Alignment Group

Align Text

Text within cells in Microsoft Excel can be aligned both vertically (top, center and bottom) and horizontally (left, center and right).

To align text vertically within a cell or cells in Microsoft Excel:

  1. Select the cell or cells in which you wish to align the text.
  2. On the HOME tab, in the Alignment group, click either the Top Align, Middle Align or Bottom Align command:

To align text horizontally within a cell or cells in Microsoft Excel:

  1. Select the cell or cells in which you wish to align the text.
  2. On the HOME tab, in the Alignment group, click either the Align Text Left, Center or Align Text Right command:

Wrap Text

By default, text in Microsoft Excel remains on one line. Wrapping text is a way of getting text to show up on multiple lines within a cell. See the following example:

To wrap text within a cell or cells in Microsoft Excel:

  1. Select the cell or cells in which you wish to wrap the text.
  2. On the HOME tab, in the Alignment group, click Wrap Text:

Indent Text

Indenting text is a way of showing that one item is a sub-item of another, as demonstrated here:

Instead of indenting sub-headings with spaces, you can do so using the Increase Indent command, which makes it a lot easier to keep all indented text equally indented.

To indent text within a cell or cells in Microsoft Excel:

  1. Select the cell or cells in which you wish to indent text.
  2. On the HOME tab, in the Alignment group, click the Increase Indent command:
  3. You can click Increase Indent as many times as you want to achieve the indentation you desire.
  4. To decrease an indent, simply click the Decrease Indent command:

Merge & Center Text

Often a label applies to multiple columns. In these cases, it is useful to merge cells to show this. In the following example, the years "2012" and "2013" each apply to four columns:

To merge cells in Microsoft Excel:

  1. Select the cells you wish to merge.
  2. On the HOME tab, in the Alignment group, click the Merge & Center command:
Next