<div>
I don't think you can. It's a big nuisance. Sorry.
</div>


I don't think you can. It's a big nuisance. Sorry.

<div>
Here's an interesting way around the problem without a macro - <a href="http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html" rel="ugc">http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html</a><br />
<br />
May or may not work - try it out!
</div>


Here's an interesting way around the problem without a macro - http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html [http://excel.tips.net/T003207_Automatic_Row_Height_For_Merged_Cells_with_Text_Wrap.html]

May or may not work - try it out!

<div>
<div class="content wysiwyg-content">
How do I enable auto size of an excel row height when cells are merged and I have text wrapping enabled? I can't un-merge the cells,
</div>
</div>


How do I enable auto size of an excel row height when cells are merged and I have text wrapping enabled? I can't un-merge the cells,

MS Excel how to auto size row height when cells are merged

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.