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?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

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"?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,052
Messages
5,835,144
Members
430,342
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top