Excel 2007's Wrap Text command makes formatting cells a snap

A common formatting task in Excel is setting text to wrap within a cell. As Mary Ann Richardson explains, Excel 2007 now makes this job a one-click operation.

Before Excel 2007, you would have to go to the Cell Formatting Dialog box to tell Excel to wrap text in a cell. With Excel 2007, you simply click a command on the Home tab. For example, suppose you want to use Wrap Text instead of changing the column width to keep your column labels from overlapping, as shown in Figure A.

Figure A

overlapping text

Follow these steps:

  1. Select B2:C2 (Figure B).

Figure B

selected cells

  1. On the Home tab in the Alignment group, click Wrap Text.
Now the labels in B2 and C2 no longer overlap on to adjacent cells (Figure C).

Figure C

wrapping text

Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox