Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

auto size a merged cell

auto size a merged cell

auto size a merged cell

How do you make a merged cell (Columns) auto size in height when someone types in more data than it can display?

RE: auto size a merged cell

You can go into forma tcells, and select the wrap text option.

RE: auto size a merged cell

I have that option selected. I have tried to select the auto row height but it won't let me.

RE: auto size a merged cell

Excel (I'm using 2002 SP3) seems very inconsistent about resizing cells to fit the text when 'wrap text' is enabled.  It seems that if the row height has been manually adjusted (by dragging the cross hair when the cursor is over the row indicators) it overrides the automatic height adjustment.  

I've also found that if you enable 'wrap text' after the cell is 'overfilled' it won't adjust it.  Sometimes selecting the text and then pressing <Enter> instead of simply selecting another cell will get the height to automatically adjust.  

I typically make a new spreadsheet, then enable 'wrap text' for the entire spreadsheet (or the required cells), and then paste the data into the new spreadsheet.  

Let me know if you find any other techniques.  

RE: auto size a merged cell

As far as I'm aware, the autosize (for row height) just does not work for merged cells?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close