Microsoft Office Tutorials and References
In Depth Information
Altering the Alignment
Tampering with how the text wraps
Traditionally, column headings in worksheet tables have been a problem —
you had to keep them really short or abbreviate them if you wanted to avoid
widening all the columns more than the data warranted. You can avoid this
problem in Excel by using the Wrap Text button in the Alignment group on
the Home tab (the one to the immediate right of the Orientation button). In
Figure 3-14, I show a new worksheet in which cells B2:H2 contain the names
of various companies within the vast Mother Goose Enterprises
conglomerate. Every company name that spills over to a column on the right that
contains another name is truncated except for the Little Bo Peep Pet Detectives
name in the last column in cell H2.
Figure 3-14:
A new
worksheet with
truncated
column
headings in
row 2.
Rather than widen columns B through H sufficiently to display the company
names, I use the Wrap Text feature to avoid widening the columns as much as
these long company names would otherwise require, as shown in Figure 3-15.
To create the effect shown here, I select the cells with the column headings,
B2:H2, and then click the Wrap Text button in the Alignment group on the
Home tab.
Figure 3-15:
A worksheet
after using
Wrap Text
to display
all the
headings
without
widening their
columns.
Search JabSto ::




Custom Search