Solved

WordWrap w/Row Height Adjustment

Posted on 2000-02-27
6
993 Views
Last Modified: 2006-11-17
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.

Thanks.
0
Comment
Question by:neoshiro
6 Comments
 
LVL 17

Expert Comment

by:calacuccia
Comment Utility
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.

Calacuccia
0
 

Author Comment

by:neoshiro
Comment Utility
Yes, it was '97.
0
 
LVL 4

Expert Comment

by:Noggy
Comment Utility
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 :-( .
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Expert Comment

by:klyjen
Comment Utility
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.

klyjen
0
 

Accepted Solution

by:
JenMartinez earned 25 total points
Comment Utility
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.
0
 

Author Comment

by:neoshiro
Comment Utility
JenMartinez,
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!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will show you how to use shortcut menus in the Access run-time environment.
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now