Excel 2007
Wrap Text

The images were created while running Windows XP.

Wrap Text

In Excel, a cell can have multiple lines of text through an option called Text Wrapping. Text wrapping can be created several ways:

I prefer using the ALT ENTER option because the text wrapping will remain no matter how wide the column is. However, you should use the option that you feel most comfortable with.

When the Wrap Text option is used, it may be necessary to adjust the column width or row height. Click and drag to adjust the column width or row height.

  1. Using the ALT ENTER keys
  2. Use the Wrap Text Icon on the Home Ribbon (Alignment Group)
  3. Use the Format Cells dialog box and choose Wrap Text.

ALT ENTER

  1. Type: Yearly
  2. Press ALT and ENTER
  3. Type: Sales
  4. Press ENTER
Type:  Yearly.

Press ALT and ENTER.

Type:  Sales.  Press ENTER.

Wrapped Text.

Wrap Text Icon

  1. Select A1. Type: Linked Sales
  2. Press ENTER
  3. Select A1
  4. Click the Wrap Text icon.
In A1, Type:  Linked Sales.  Press ENTER.  Select A1.  Click the Wrap Text Icon on the Home Ribbon (Alignment Group).

Wrapped Text.

Format Cells, Wrap Text

  1. Type: Yearly Sales
  2. Press ENTER
  3. Right mouse click the cell with Yearly Sales
  4. Select Format Cells
  5. Click the Alignment Tab
  6. Click Wrap Text
  7. Click OK or press ENTER
Type Yearly Sales and press ENTER.  Right mouse click the cell with Yearly Sales and choose Format Cells.

Click the Alignment Tab.  Click Wrap Text.  Click OK or press ENTER.
Updated August 23, 2007