Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Wrap Text problem

Status
Not open for further replies.

jonbatts

Programmer
Apr 12, 2005
114
US
I'm having trouble with "Wrap Text". I have a cell which has "Wrap text" checked in the alignment section of "Format" and most of the time it wraps find and auto-expands the height of the row it is in. But, sometimes it wraps without auto-expanding the row. After messing with it I realize that I can get the cell to auto-expand if I add a few more characters. Its almost like Excel is using two different algorithms to determine when to wrap, and when to auto-expand, and the one which tells it when to auto-expand isn't working the way I think it should; i.e. if the text wraps, auto-expand the row. Any ideas? Thanks.
 
Hi Jon,

This behaviour may be occurring because Excel is trying to keep the formatting correct for printing but is unable to display it correctly. This problem seems to be especially acute at small point sizes and varies from font to font.

Cheers

[MS MVP - Word]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top