Microsoft Office Tutorials and References
In Depth Information
Getting Oriented
By default, clicking Merge & Center on our selection of J12 through N12 brings about (Figure 4–
66):
Figure 4–66. A mega, merged cell
This option resolves an old spreadsheet problem—the need to center a title over a collection of
columns (Figure 4–67):
Figure 4–67. How to center that title over all those months?
In the old days, users had to resort to all manner of contortions in order to situate that title in the
middle of the row above the month names, including trying to locate a “middle” column. But we’re
working with 12 columns here, aren’t we? There is no middle column. Merge & Center will turn A1:L1
into one cell (of course that’s the range you need to select), after which Monthly Sales will be precisely
centered within the new super cell—which is still called A1.
The drop-down menu attaching to Merge & Center affords three additional options. Merge Across
allows you to Merge & Center data in consecutive rows . Thus if you start with this (Figure 4–68):
Figure 4–68. Text, one word per cell
You see that I’ve already selected the cells to be merged. Clicking Merge & Center: Merge Across
results in this (Figure 4–69):
 
Search JabSto ::




Custom Search