• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1003
  • Last Modified:

WordWrap w/Row Height Adjustment

I'm using Excel 2000.  For some reason, when I have text in the cell that exceeds the width, when I do Format/Cell/Alignment/WrapText, it does not expand the row height to accommodate the wrap.  I have to manually increase the row height to view the entire text.

It used to adjust all at once - at least with a previous version on Excel.

1 Solution
Hi Neoshiro,

what was the previous version: Excel 97 ?

Don't have 2000, but in Excel 97, the WrapText adjusts row height automatically, except for merged cells.

neoshiroAuthor Commented:
Yes, it was '97.
I've got both so I'll have a little look at 2000. Mind you, I used to have problems with 97 too at times: sometimes it would make the rows too large when it did this - and a double-click on the row boundary wouldn't fix it either :-( .
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

neoshiro -- In my experience, the word wrap often only adjusts the cell height when the cell formatting is applied BEFORE the text is typed.  If you realize after the fact that you want to have the text wrap, the row height doesn't adjust unless you do it manually, or by auto-fitting the row (the same way you can autofit a column).  

And that's all in 97.

Another thought is that you may have manually adjusted the height before hand.  When you do this, Excel automatically turns off the auto adjust feature.
neoshiroAuthor Commented:
You got it!  I tested this by opening a new worksheet, input a long sentence in a cell, then did the Format/ Cell/ Alignment/ WrapText and it expanded the row height automatically.

Thanks, JenMartinez!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now