Wrapping Text in Excel - AdvantEdge Training & Consulting

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.
Wrapping Text in Excel
The text can be cut off if the next cell is occupied.
Wrapping Text in Excel
The text can also wrap, making the cell taller.
Wrapping Text in Excel

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 ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top