Microsoft Office Tutorials and References
In Depth Information
Figure 4–61. Text, normally sized
Shrink to Fit will recast the text to look like this (Figure 4–62):
Figure 4–62. Look honey, I shrunk the text
Well, you get the idea.
Finally, the Merge cells option does as it says. It actually consolidates, or merges, selected
contiguous cells into one mega cell. Thus if I start with this entry in cell J12 (Figure 4–63):
Figure 4–63. Text in cell J12
And I then select cells J12 through N12 and click the Merge cells command, I get (Figure 4–64):
Figure 4–64. A merged cell
And what you’re looking at now is all J12; all the selected cells have been absorbed by one cell—
J12—in which I typed my data. All of which raises a fairly obvious question: what does that do for me?
Answer: not much.
But what you really may want to do is merge these cells as we’ve demonstrated above, and then
center the data in the new, super-sized cell. And indeed, there’s an Alignment Group button— Merge &
Center —which does exactly that (Figure 4–65):
Figure 4–65. The Merge & Center button