Home / Articles / How to Wrap Text and Formulas on Multiple Lines in Excel

How to Wrap Text and Formulas on Multiple Lines in Excel

How to Wrap Text and Formulas on Multiple Lines in Excel Image
  • Posted on 17th Aug, 2022 13:51 PM
  • 1132 Views

Learn how to use shortcut keys and menu options to wrap text and formulas on multiple lines in a worksheet cell or in the formula bar.

What to Know

  • Select a cell and enter text; press and hold Alt. Press Enter and release Alt. For more than two lines of text, press Alt+Enter at each line's end.
  • Wrap existing text: Select the cell, press F2, place the cursor where you want the line broken. Press and hold Alt. Press Enter and release Alt.
  • Or, use the Ribbon: Select the cell that contains the text to be wrapped. Select Home > Wrap Text. The text is broken into two lines.

This article explains how to use Excel's wrap text feature, which is a handy formatting tool that allows you to control the look of cell entries and headings in a worksheet. Another use for wrapping text is to break long formulas onto multiple lines in cells or in the formulas bar so they're easier to read and edit. Instructions cover Excel 2019 through 2007 and Excel for Microsoft 365.

Use Shortcut Keys to Wrap Text as You Type in Excel

The shortcut key combination for wrapping text in Excel is the same one used to insert line breaks (sometimes called soft returns) in Microsoft Word, Alt+Enter. The result looks like this:

To wrap text inside a cell:

  1. Select the cell where the text will be entered.

  2. Type the first line of text.

  3. Press and hold the Alt key.

  4. Press the Enter key.

  5. Release the Alt key.

  6. The insertion point moves to the line below the text just entered.

  7. Type the second line of text.

  8. To enter more than two lines of text, press Alt+Enter at the end of each line.

  9. When you've entered all the text, press Enter or select another cell.

Use the Alt+Enter shortcut key combination to wrap or break long formulas into multiple lines in the formula bar.

Use Shortcut Keys to Wrap Existing Text in Excel

Shortcut keys aren't just limited to text you are currently typing. As the image below shows, text can be wrapped after it has been entered into a cell.

If you have a selection that has already been typed, follow these steps to convert the cell with a few key presses:

  1. Select the cell containing the text you want to change.

  2. Press the F2 key or double-click on the cell to place Excel in Edit mode.

  3. Place the cursor where you want the line to be broken.

  4. Press and hold the Alt key.

  5. Press the Enter key.

  6. Release the Alt key.

  7. To break the same line of text a second time, move the cursor to the new location and repeat steps 4 to 6.

  8. When you're finished, press Enter or select another cell to exit Edit mode.

Use the Ribbon to Wrap Text in Excel

As an alternative to using shortcut keys, the ribbon presents a wrapping option. If you don't want to memorize key commands, this method is for you.

  1. Select the cell that contains the text to be wrapped.

  2. Select Home.

  3. Select Wrap Text.

  4. The labels in the cell are fully visible. The text is broken into two lines or into multiple lines with no spillover into adjacent cells.

Excel automatically wraps the text in a cell to match the width of the cell. If you want more control, use the shortcut keys.

Was this page helpful?
How to Wrap Text and Formulas on Multiple Lines in Excel View Story