1. Computing

Excel Wrap Text

Wrap Long Titles and Headings on Two Lines in Excel

By

Wrap Text in Excel

Wrap Text in Excel

© Ted French

Excel's wrap text feature is a handy formatting feature that allows you to control the look of labels and headings in your spreadsheet.

Wrap text allows you to place text on multiple lines within a single cell rather than have the text spread over multiple cells in the worksheet.

Example using Excel's wrap text feature:

For help with this example, see the image to the right.

  1. In cell D1 type the text: Monthly Income and press the Enter key on the keyboard.

  2. Since the text is too long for the cell, it should spill over into the cell E1.

  3. In cell E1 type the text: Monthly Expenses and press the Enter key on the keyboard.

  4. By entering data into E1 the label in cell D1 should be cut off at the end of cell D1. As well, the text in E1 should spill over into the cell to the right.

  5. To correct the problems with these labels, drag select cells D1 and E1 on the spreadsheet to highlight them.

  6. Click on the Home tab.

  7. Click on the Wrap Text button on the ribbon.

  8. The labels in cells D1 and E1 should now both be fully visible with the text broken into two lines with no spill over into adjacent cells.

©2014 About.com. All rights reserved.