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.
Follow these steps:
- Select B2:C2 (Figure B).
- On the Home tab in the Alignment group, click Wrap 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.