How to Wrap Text and Formulas Across Multiple Lines in Excel – Knowligent
How to Wrap Text and Formulas Across Multiple Lines in Excel

How to Wrap Text and Formulas Across Multiple Lines in Excel

HomeHow to, TechHow to Wrap Text and Formulas Across Multiple Lines in Excel

This article explains how to use Excel's Wrap Text feature, a useful formatting tool that lets you control the appearance of cell entries and headings in a worksheet. Another use for wrapping text is to split long formulas into multiple lines within cells or in the formula bar, making them easier to read and edit. Instructions apply to Excel 2019 through 2007 and Excel for Microsoft 365.

How to get multiple lines in an Excel cell using text wrapping?

The shortcut 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 in a cell:

Select the cell where the text is to be entered.