Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 2007 - Wrap text problem

45 views
Skip to first unread message

marcy

unread,
Jun 17, 2008, 1:15:01 PM6/17/08
to
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

unread,
Jan 29, 2011, 1:31:41 PM1/29/11
to
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

unread,
Jan 29, 2011, 1:35:31 PM1/29/11
to
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

unread,
Jan 29, 2011, 3:27:38 PM1/29/11
to
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


0 new messages