How to wrap text in Microsoft Excel in 3 ways, to make sure that all of your data is visible

There are two ways to wrap text you can edit the settings so that cells wrap automatically, or you can manually break up lines to wrap text.
Visit Business Insider's homepage for more stories .

Wrapping text in an Excel cell makes it easier to view all of the data in that cell. A wrapped cell expands as you type into it, so it will always fit everything you type.

Wrapping text isn't the default option in Microsoft Excel , but it's a simple adjustment to make. There are two ways to wrap text in Excel you can either edit the settings to wrap text automatically or you can manually enter line breaks.

Note, however, that you may have to adjust the row height, to ensure that all your text is visible.

Check out the products mentioned in this article:

Microsoft Office 365 Home (From $99.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Lenovo IdeaPad 130 (From $299.99 at Best Buy)

How to wrap text in Excel automatically

1. Open Excel on your Mac or PC and select the cells that you want to format.

2. Select the "Home" tab, then find the wrap text icon and click "Wrap Text."

Screen Shot 2019 11 11 at 3.55.38 PM Kelly Laffey/Business Insider

3. Alternatively, you can select "Format" from the menu at the top, hit "Cells" and then select "Wrap Text" under the "Alignment" tab.

Screen Shot 2019 11 11 at 3.56.04 PM William Antonelli/Business Insider

4. Note that the size of the cell impacts the text that you see. For example, if you change the width of the cell, the data wrapping will automatically adjust to fit the new space.

Screen Shot 2019 11 11 at 3.55.41 PM William Antonelli/Business Insider

If your wrapped text isn't all visible, it could be because the row is set to a specific height that can't accommodate the amount of text, or that the text is in a range of cells that's been merged.

Here's how to adjust the height of a cell:

1. Select the cell or cells that you want to adjust the row height of.

2. Select the "Format" tab, then select "Height."

3. From there, you can either:

Select "AutoFit Row Height" to automatically adjust the row height to fit your text.
Specify the exact height of the row by selecting "Row Height" and typing the height (in pixels) into the box.