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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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?
 
Upvote 0
More information.
It appears to be isolated to situations where both merge and wrap co-exist, that the auto row height is confused.
 
Upvote 0
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"?
 
Upvote 0

Forum statistics

Threads
1,211,737
Messages
6,103,629
Members
447,873
Latest member
dolphin_tlp

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
Back
Top