OverlayFlow

How to Wrap Text in Excel Cells Automatically ?

Tired of long text overflowing into adjacent cells? Learn how to automatically wrap text in Excel to keep your data neat, organized, and fully visible within the cell's boundaries.

Select cells, then go to the Home tab and click Wrap Text.

How to Automatically Wrap Text in Excel

1

Select the Cell(s)

Click on a single cell or click and drag to select a range of cells, a column, or a row containing the text you want to wrap.

2

Navigate to the Home Tab

Look at the ribbon at the top of the Excel window and ensure the Home tab is selected.

3

Find the Alignment Group

On the Home tab, locate the Alignment group. This section contains various text formatting options.

4

Click Wrap Text

Click the Wrap Text button. The text in your selected cells will now automatically adjust to display on multiple lines within the cell, fitting the column width.

💡 Pro Tips

Pro Tips for Wrapping Text

âŒ¨ī¸

Keyboard Shortcut

For a faster workflow, select your cells and press Alt + H + W to quickly toggle text wrapping.

â†Šī¸

Manual Line Breaks

To control exactly where a line breaks, double-click the cell and press Alt + Enter to insert a manual line break.

â†”ī¸

Adjust Column Width

Text wrapping is dependent on the column width. Widen or narrow the column, and the text will re-wrap automatically.

â†•ī¸

AutoFit Row Height

Excel usually adjusts row height automatically. If it doesn't, go to Home > Format > AutoFit Row Height to fix it.

Need help right into Excel?

Try Overlayflow, it's an AI software assistant that can answer any questions and show you on screen where to click!

Now available for any popular app.
3-day free trial. No credit card required. Then $59 one-time payment.