1. Computing

Wrap Text on Two Lines in Excel

By

Excel Wrap Text Feature
Excel Wrap Text

Excel Wrap Text

© Ted French

Wrap Text on Two Lines in Excel

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

Rather than widening worksheet columns to make long headings visible, wrap text allows you to place text on multiple lines within a single cell.

Excel's Wrap Text Example

For help with this example, see the image above.

  1. In cell G1 type the text: Monthly Income and press the ENTER key on the keyboard.

  2. Since Monthly Income is too long for its cell, it will spill over into the cell H1.

  3. In cell H1 type the text: Monthly Expenses and press the ENTER key on the keyboard.

  4. Once data is entered into cell H1 the first label Monthly Income should be cut off.

  5. To correct the problem, drag select cells G1 and H1 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 G1 and H1 should now both be fully visible with the text broken into two lines with no spill over into adjacent cells.

Related Tutorials

©2014 About.com. All rights reserved.