Auto Row Height

FANeug

New Member
Joined
Feb 11, 2005
Messages
8
There are times when I select Text Wrap and Merge, but the row Auto Height only sees one row of text. Why?

Also, there are times when the auto row height will display all the text on the screen, but when printed (or in print preview) the bottom line or two is cut off. Why?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Harvey

Well-known Member
Joined
Nov 18, 2004
Messages
953
I only see this happen when I manually adjust the row height, so I guess it must have something to do with that. Can you tell what exactly you have to do to make it stop auto resizing?
 

FANeug

New Member
Joined
Feb 11, 2005
Messages
8
Actually, I just double click at the bottow of the row bar to auto-resize the row.
 

FANeug

New Member
Joined
Feb 11, 2005
Messages
8
More information.
It appears to be isolated to situations where both merge and wrap co-exist, that the auto row height is confused.
 

grd

Board Regular
Joined
Oct 19, 2005
Messages
210
If merge is used as well as wrap you will only automatically see 1 row.

In that situation, I increase the font of a cell beyond the print range to make sure the wrapped lines always get printed.

It would be uesful if MS sorted this or is it a "design feature"?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,284
Messages
5,571,305
Members
412,380
Latest member
Angelagrace
Top