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:
To align text horizontally within a cell or cells in Microsoft Excel:
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:
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:
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: