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:Alignment Group

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:Alignment Group

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:Wrapped Text

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:Wrap Text in Alignment Group of Home Tab

Indent Text

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

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:Increase Indent in Alignment Gourp of Home Tab
  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:Decrease Indent Command in Alignment Group of Home Tab

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:Merged 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:Merge and Center in Alignment Group of Home Tab
Next