Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
In Figure 3-12, you see the result: The cells in row 1 of columns A through
E are merged into one cell, and now the title is properly centered in this
“super” cell and consequently over the entire table.
Figure 3-12:
A worksheet
title after
merging and
centering
it across
columns A
through E.
If you ever need to split up a supercell that you’ve merged with Merge &
Center back into its original, individual cells, select the cell and then simply
click the Merge & Center button in the Alignment group on the Home tab
again. You can also do this by clicking the drop-down button attached to the
Merge & Center button on the Home tab and then clicking Unmerge Cells on
this drop-down menu (a few more steps, I’d say!).
Intent on indents
In Excel 2013, you can indent the entries in a cell selection by clicking the
Increase Indent button. The Increase Indent button in the Alignment group
of the Home tab sports a picture of an arrow pushing the lines of text to the
right. Each time you click this button, Excel indents the entries in the current
cell selection to the right by three character widths of the standard font. (See
the section “Futzing with the Fonts,” earlier in this chapter, if you don’t know
what a standard font is or how to change it.)
You can remove an indent by clicking the Decrease Indent button (to the
immediate left of the Increase Indent button) on the Home tab with the
picture of the arrow pushing the lines of text to the left. Additionally, you
Search JabSto ::




Custom Search