Wrapping Text in Excel

Text that cannot fit within the width of a single cell can behave in one of three different ways.

The text can run into the next cell, if the cell to the right is empty.

overrun

The text can be cut off if the next cell is occupied.

cut_off

The text can also wrap, making the cell taller.

wrapping

Making text wrap in Excel

Select the cell or cells that contain the text that needs to wrap. Then under the Home tab, click Wrap Text in the Alignment group. Your cells with automatically expand to fit the wrapping text.

You can adjust the width and height of the cells to make the text to best fit the cell.

Tips for making data readable.

excel_alignmentWith one cell wrapping text, the other cells in the chart may become more difficult to read. Changing the cell alignment can help. In the Alignment group under the Home tab, there are 6 alignment options. The top row of options controls the location of the text vertically, and the bottom row controls the text horizontally.

Merge and Center

merge_centerAnother option for making text more readable is using the Merge and Center feature. This combines cells and centers the data in the cell.

Select two or more cells in your worksheet, only one of which contains data. Then right click on the group and choose the Merge and Center button.

For more excel techniques see our Excel Training Class.