Make Excel 2007 Wrap Text in Cells
In Excel if you have a long entry in a cell the text automatically spans into multiple columns. Here’s how simple Excel 2007 makes the task of wrapping text in worksheet cells.
Select the cell(s) you you want to wrap. Click Home on the Ribbon and select Wrap Text.
That’s all there is to it! Excel will wrap the text in the cell and also increase the height of the cell row.
This article was originally written on 07/1/07
Daily Email Updates
You can get our how-to articles in your inbox each day for free. Just enter your name and email below:
Hi Geek,
I was wondering if there was a way to make the word wrap, instead of expanding the cell vertically, to move to the cell under it.
Pat
Help – Just got Excel 2007 and one of my favourite helps has gone.
I used to be able to enter a fairly long sentence into a cell (say A1) then justify it to span across an area covered by cells A1 to D1 and A2 to D2 etc rather than having to wrap into a single cell.
Can you do this now?
Gary
Help – i need to split text in one column so that, when mail merging it autmatically goes onto other lines (in the address)
I.e stopping it from saying
rose cottage, tunnel road, galley common
i want it to say
rose cottage
tunnel road
galley common
i have all the above text in 1 column which is my problem.
Please help! x
When I select the cell that I want to Wrap Text, it does not wrap the text in the cell and also increase the height of the cell row. I don’t understand why it will not increase the cell height and wrap the text so that you can see everything within that cell without being on the cell and veiwing the content within the formula bar
I would like to be able to decide WHERE it wraps the text. for example, in a column of phone numbers, some people have two numbers. I want to choose where to break for the 2nd # to be under the first (but still in the same cell). just re-sizing the column to have it break in that spot will only affect that cell….because in other cells, the phone # might have a ‘ph’ next to it and it won’t break before the ph, it will only break where i made it break based on the first cell. does that make sense?
how to workout the macro and formula
Thanks a bunch. That really helped out a lot. I was doing it another way but then i forgot how to do it so i had to goggle it. Your way is the fastest and easiest. Kudos to you!