How about this one, another formatting problem.

[proof]

http://img242.imageshack.us/img242/3573/excelyh8.gif

The picture shows what is happening, how do I fix it, so the information is truncated like the top 3 cells?

Thanks!

There is information in the cell below this one.

Thanks!

 

[Oaktree]

Looks like you have wrapped text in that cell. Try selecting the cell, going to format --> cells --> alignment, and unchecking "wrap text".

 

[proof]

The cell actually contains mutiple lines of text, which I seperate by hittin Alt-Enter after each line. Word wrap is checked, but it is also checked on the first three cells which are truncated the way I want them.

 

[Oaktree]

Did you manually adjust the row heights? You can just set the row height to whatever you'd like (format --> row --> height) which will "ignore" the word wrap sizing...

 

[proof]

That works. You have to do it manually every time though?

 

[Oaktree]

You could just wait until you're done making adjustments, select all of your rows at the same time, and follow the same steps.