How to Wrap Text in Excel… in a Few Seconds!

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

Excel has some great tools for working with text, but sometimes it’s the simplest things that throw you off.

Like trying to figure out how to get text to wrap so it doesn’t take up your entire window.

So we’re going to help you out. Here’s what you need to know about text wrapping, and how to do it in Excel.

What is text wrapping?

To be clear on what we’re talking about here, I’ll define text wrapping for you.

Here’s unwrapped text:

unwrapped-text

It’s a long string of text that continues all the way across the screen. And because it’s longer than a sentence or two, it runs right off the end of the page.

On the other hand, wrapped text looks like this:

wrapped-text

The text is “wrapped” so it fits in the specified width of the column. Line breaks are added to keep the text from being any wider.

How to wrap text in Excel

Wrapping text in Excel is super easy.

First, select the cells that you’d like to have wrapped text.

Then, in the Home tab of the Ribbon, click the Wrap Text button:

wrap-text

That’s really all there is to it.

When you first wrap text, though, you’ll probably see something like this:

narrow-wrap

To fix this, adjust the column width.

Problem solved, right?

Well, maybe.

You might end up with this problem:

low-text

To finally get the right fit, select the cells with your text, then click Format > AutoFit Row Height:

autofit-row-height

Finally, we have the text adjusted so it looks nice:

wrapped-text

Become a wrap star

It’s a simple thing, but learning to quickly wrap text in Excel can save you a lot of headaches if you’re working with text.

Looking for other cool ways to format your text? Here’s how to strikethrough text in Excel!

And it’s as easy as clicking a single button.

Wouldn’t it be nice if you could fix all your Excel problems so easily? Well, equipped with the right skills, you can!

Kasper Langmann, Co-founder of Spreadsheeto