Automaticaly expand merged cells height

ljubinville

New Member
Joined
Jan 30, 2008
Messages
3
Hi,

How can I set merged cells (with wrap text option activated) to automatically expand when current height is exceeded ?

I've unsuccessfully tried many ways.

Can somebody help ? :confused:
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

jberwald

Board Regular
Joined
May 3, 2005
Messages
205
Excel will not change row height with merged cells - but you can try this. Choose a column at the far right of your workbook that won't show or print, lets say column Z.

With your merged cells starting in C2, have it formated to wrap text.

Extend Column Z width to just a little narrower then the merged cells width. Then put this formula in Z2. =C2. Format Z2 to wrap text.

The idea is: When you type in your merged cells it will copy over to a non-merged cell. The non-merged cell will expand to make the row the proper size.

Hope this works for you.
 

Forum statistics

Threads
1,136,257
Messages
5,674,665
Members
419,521
Latest member
Jennifer4Dillon

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