Sleeper: Using "Autofit" for merged cells

[Liran-a]

Hello.
I would like to ask two questions regarding the Row AUTOFIT operation in Excel:


I would like to perform AUTOFIT operation on a specific row in Excel, that contains merged cells. If I Unmerge the cells, it's not a problem, but I would rather leaving the cells merged. My question is: How to AUTOFIT the row with the merged cells?
I would like to AUTOFIT a specific row, but this function doesn't work properly: it doesn't really AUTOFIT the row. However, when I pull the row -border by myself, it's possible to see it's entire content. What is the reason for it? Can it be fixed?
Thank you very much.

[shades]

Howdy. Often Autofit seems not to work after the rows have been individually/manually changed.

BTW, as an aside: Merged Cells are to be avoided at all costs not only for your situation, but it messes up many other Excel capabilities. Avoid Merged Cells unless at gun point - but make sure the gun is loaded before you give in too quickly. :)

[austenr]

Agreed Shades. It will cause certain macros not to run. If they have you at gunpoint make sure they give you a last wish and a meal before execution. :thumb