Written by:

Written by:

Thomas Szigeti

Text Wrap in Excel

When I was new to excel I had a bit of trouble understanding how excel was handling text in a cell.
In this short post I will explain the Wrap text function to you.

In excel if you type a long-long text in a cell it will try to extend over on the right. 

This if there is no data in the cells on the right. If there is data in there then Excel will simply cut off the display of your text at the border of the cell you are in. 

You can always make the whole column wider so your text will show, or you can just double click the side of the colum to use the column autofit feature.

What to do if I have too many columns and I can’t make them wider?

You can use the Wrap text feature.

This feature lives on the ribbon in the Alignment Group on the Home tab.

Wrap text button on excel ribbon

Simply select the cell you want to wrap the text in, and press the button.

Be aware that if you hawe multiple cells selected, and one has the wrapped text, the other one doesn’t then the wrap text button will look solid. This is to show you that you have multiple settings in your selection.

Also worth mention that this feature will look at your column width. If the column is wide enough to contain your text in the cell, then you can press the wrap text button all day long, nothing will happen.
So first you need to narrow your column so your text is overhanging or cut off. Then apply Wrap text from the ribbon.

 

I will show you in this short video.
Funny: Sometimes people mispell wrap text laughing they like:
wrap text in exel, wrap text xcel, wrap text in exce, wrap test excel, wrap text ecel, warp text in excel, wrap text on excel, text wrap in xcel, wrap text in excell, wrap test in excel, wrapping text on excel, wrap text excell, wrap text exce, wrap text exel, wrap text i excel.
I guess we have to show them the right way of spelling it.

Come and visit us.

Come and visit excelangel on Facebook to find and join the growing community of true office workers.

Oh, I almost forgot.
Drop us a like while you there…

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]