How to wrap text in cells in Excel

Abstract

Before we look at alignment, we need to look at text wrapping.

Wrapping text in cells is a key feature in Excel.

Wrapping text allows you to fit multiple lines of text in a single cell.

Let’s take a look.

If those columns do contain data, the text will be cut off at the cell border.

There are a couple of ways to handle this in Excel.

One obvious solution is just to make the column wider.

However, this isn’t really an option when you have a lot of other columns to display.

A better solution is to wrap the text in cells that contain more content.

Excel provides a “Wrap Text” button in the Alignment group on the home tab of the ribbon.

This button toggles text wrapping on and off.

it’s possible for you to also control text wrapping from the Format Cells dialog box.

When Wrapping is on, you’ll see the Wrap Text checkbox checked on the Alignment tab.

Also be aware that text wrapping behaves differently depending on the width of the column.