Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Wrapping text in merged cell

  1. #1
    Guest

    Default

    Excel 97 will not perform wrapping of text in merged cells. The automatic wrapping was okay in the single cell and increased the row height appropriately but when two or more cells are merged, no wrapping occurs and the row height doesn't change. I've tried reformatting to no avail.
    pkra@hotmail.com

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It works for me. I merged the cells, then went to Format-Cells (Ctrl+1), and clicked the Wrap Text check box in the Alignment tab. Text was then wrapped.

  3. #3
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    954
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Also ensure that you are changing the fields at the top to suit your preferences.

    Horizontal to right and Vertical to Top.
    George J

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Guys --

    BTW I seem to recall E97 wont if top aligned.. just a point..

    Rdgs
    ==========
    Jack

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •