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

Follow these steps:

  1. Select B2:C2 (Figure B).

Figure B

  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


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.