Software

Use Editing, Fill, Justify to add instructions to your Excel 2007 worksheets

Excel 2007's new Editing, Fill, Justify feature makes it easy to to arrange instructions in a readable layout. Here's how to make your Excel asides more readable and ready to format as you wish.

When you need to add instructions to an Excel 2007 worksheet, they usually look something like Figure A.

Figure A

Figure A

Each line has a separate cell and overflows onto the neighboring cells. In this case, each of the four lines was entered in cells A1 through A4, respectively. In earlier Excel releases, it was challenging to arrange these lines in a readable layout, but Excel 2007's new Editing, Fill, Justify feature makes it easier. To arrange the text above to make it more readable, follow these steps:

  1. Select A1:G9.
  2. Click the Home tab, and then in the Editing group, click the Fill command drop-down arrow.
  3. Click Justify at the bottom of the list.

Excel wraps the text so that each line is shorter than the selection range (Figure B).

Figure B

Figure B

You can now select and format the text as desired.

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