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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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.
 
Upvote 0

Forum statistics

Threads
1,217,438
Messages
6,136,616
Members
450,022
Latest member
Joel1122331

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