How-To Geek
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.
Got Feedback? Join the discussion at discuss.howtogeek.com
Comments (12)
Programmer by day, geek by night, The Geek, also known as Lowell Heddings, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on Google+ if you'd like.
- Published 07/1/07
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!
To decide where to wrap the text all you need to do is hit alt-enter where you want it to split and then click that text wrap button and there you have it…
Wow that was so easy to word wrap I now feel like an idiot…LOL
Thanks a bunch though!
@Annie
use Alt+Enter within the cell
hey is Alt + Enter
Hi Guys,
I need your help.
I want one row to be replaced by another in MS excel.
For e.g.
USAGE CHARGES TOTAL COST
USAGE DISCOUNT VAT
RECURRING CHARGES TOTAL EXCL VAT
RECURRING DISCOUNT ONE OFF DISCOUNT
ONE OFF CHARGES <> ADJUSTMENTS
ADJUSTMENTS ONE OFF CHARGES
ONE OFF DISCOUNT RECURRING DISCOUNT
TOTAL EXCL VAT RECURRING CHARGES
VAT USAGE DISCOUNT
TOTAL COST USAGE CHARGES