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.

3 comments
mrbillbenson
mrbillbenson

Was there earlier than 2003 ... since 97 at least. I think Excel forgot to enhance this feature when they made the in-cell character limitations more robust. It truncates the data at 255 characters, with no warning (that is the most insulting part). Worse than Twitter which won't let you tweet past 140 characters, this just replaces cells and data with no warning. TG for Undo.

kohl
kohl

Edit, Fill, Justify is also in Excel 2003.