When your text data is long, it can look incomplete unless you wrap your text in Microsoft Excel. The “Wrap text” feature allows the contents of the cell to appear on multiple lines so that the content is easy to view at a glance. While no change occurs to the contents of the cell, the spreadsheet looks neat and professional.

If you're wondering how to wrap text in Excel, here are the four best ways. Let's take a look at each one of them.

Wrap Text in Excel Using the Keyboard Shortcut

The quickest way to wrap text in Microsoft Excel is by using the keyboard shortcut. Incredibly useful for wrapping text one cell at a time, here's a look at how to wrap text in Excel quickly.

  1. Select the cells on which you'd like to apply Wrap text.
  2. Press Alt + H + W.
  3. To wrap all the text in a spreadsheet, you can select the entire spreadsheet by clicking CTRL + A and press the keyboard shortcut.
Wrapping text in a spreadsheet

Wrap Text in Excel Using the Wrap Text Option

The most common and easiest way to wrap text in Excel is by using the Wrap Text option. Now, if you're wondering where is wrap text in Excel, you'll find it in the ribbon commands on the Home tab.

RELATED: How to Remove Spaces in Excel

  1. Select the range of cells you'd like to apply wrap text to.
  2. Go to the Home tab and the Alignment section.
  3. Press the Wrap Text command you find, and you're good to go!
Using the Wrap Text command

Wrap Text in Excel by Using the Format Cells Dialog Box

The format cells dialog box has all the formatting options you'd need to apply to a cell or a range of cells in Excel. Here's how to wrap text using the format cells dialog box.

  1. Select the range of cells and right-click.
  2. Click on Format Cells from the drop-down. You can also use the CTRL + 1 keyboard shortcut.
  3. Go to the Alignment tab, check the Wrap Text option in the Text Control section.
  4. Press OK.
using format cells option

Wrap Text in Excel by Adjusting Row Height & Column Width Automatically

When your row height does not adjust to fit all of your text automatically, you can wrap text by manually clicking and adjusting the row to fit the height. However, there's an easier way to do it. Here's a look at how to wrap text in Excel by auto-adjusting the row and column heights of your cells.

RELATED: The Best Online Courses to Master Advanced Excel

  1. Go to the Home tab.
  2. Select the Format option under the Cells section.
  3. Select AutoFit Row Height and AutoFit Column Width from the drop-down.
Wrapping text using AutoFit height

Removing Wrap Text Formatting Is Also Easy

Now that you know how to wrap text in Excel, you should also be up-to-date on how to remove the wrap text formatting. To undo wrap text, you can press the Wrap text command on the Alignment section on the Home tab, and you'll be all set.

You can also press the keyboard shortcuts Alt + H + W to undo the text wrapping you've done. In fact, using the same commands you used to wrap text, you can remove the formatting.

Wrapping Text Is a Good Idea

When you wrap text using any one of the three ways mentioned above, you make it easier to view all the data in a cell. This adds a level of convenience and productivity to your workdays.

Moreover, wrapping text in Excel makes your spreadsheets look well-formatted and professional. A wrapped text cell also expands while you type into it, so it'll always fit all that you type.