SEARCH

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.

4    5

That’s all there is to it!  Excel will wrap the text in the cell and also increase the height of the cell row.

6

Lowell Heddings, better known online as the How-To Geek, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on if you'd like.

  • Published 07/1/07

Comments (12)

  1. Pat

    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

  2. Gary

    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

  3. Tanya

    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

  4. Merian

    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

  5. annie

    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?

  6. raj kumar

    how to workout the macro and formula

  7. Juanita10

    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!

  8. Helper

    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…

  9. Sweetie

    Wow that was so easy to word wrap I now feel like an idiot…LOL

    Thanks a bunch though!

  10. Dev

    @Annie

    use Alt+Enter within the cell

  11. Help to other

    hey is Alt + Enter

  12. Pushpraj Singh

    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

Get Free Articles in Your Inbox!

Join 134,000 newsletter readers

Email:

Go check your email!