iSumsoft » Resources » Office » How to Select Cells Range/Rows/Columns in Excel

How to Wrap Text Automatically in Excel Cells

In Microsoft Excel and other spreadsheet programs, Wrap Text is a feature that wraps the text in a cell. This is a guide describing how to wrap text in a cell automatically. Follow this guide to make wrap text work better for you.

Wrap long text string

2 ways to wrap text automatically

To make the text easier to read and better fit for printing, you can enable wrap text feature.

Way 1

In Worksheet, select the cell or cells range you want to format.

On the Home tab, in the Alignment group, click Wrap text.

Wrap text automatically

Data in the cell wraps to fit the column width, if you change the column width, the text wrapping adjusts automatically.

Way 2

In Worksheet, select the cells you want to format. Press Ctrl + 1 to open the Format Cells dialog.

On the Alignment tab, select the Wrap Text checkbox, and click OK.

Wrap text in all cell