Excel 2007 - Wrap text problem

[marcy]

I have a spreadsheet in Excel 2007 where the wrap text function is not
working properly. The text height is getting cut off before the full text
displays. The AutoFit Row Height function does nothing. There is no merging
or anything unusual in the workbook.

By the way, the print preview does display the full text of the cell, but
the regular worksheet view does not show the full cell. I have looked at the
maximum height (which is 409 pts) and my rows are not at that height, so I'm
not sure what's causing the problem.

Any help would be greatly appreciated!

[Judy Wiese]

After spending hours with this problem, finally figured it out. Make sure the cell to the right is BLANK. A single space in the cell to the right will prevent the text from wrapping correctly.

> Submitted via EggHeadCafe
> SQL Server Table Valued Parameters / Types - Multiple Row Inserts
> http://www.eggheadcafe.com/tutorials/aspnet/1b4677b6-3be6-4b68-897f-e4829fa8f33b/sql-server-table-valued-parameters--types--multiple-row-inserts.aspx

[Judy Wiese]

After spending hours on this, I think I've finally figured it out. Make sure the cell to the right either has text/number or is completely BLANK. A single space will keep the text from wrapping.

> On Tuesday, June 17, 2008 1:15 PM marc wrote:

>> On Saturday, January 29, 2011 1:31 PM Judy Wiese wrote:

>> After spending hours with this problem, finally figured it out. Make sure the cell to the right is BLANK. A single space in the cell to the right will prevent the text from wrapping correctly.

>> Submitted via EggHeadCafe
>> SharePoint Tip / Thought of the Day WebPart
>> http://www.eggheadcafe.com/tutorials/aspnet/14280ff8-3c9f-46bd-8214-9267e613c8ec/sharepoint-tip--thought-of-the-day-webpart.aspx

[GS]

After serious thinking Judy Wiese wrote :

You might want to read Dave Peterson's reply to Dave K under the
previous topic "Is Auto Expansion (i.e., wrap text) of a cell...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc