SSRS - Export report to Excel -HTML issue

Question

Here is my SSRS report. I set the placeholder as HTML

I export my report to Excel. First I thought something is wrong with the note. But, when I click on the cell, it shows me my note. Is there anyway to display all the note in separate cell when exporting my report?

Excel Version:

Answer 1

If you are trying to make the label mutli row or word wrap then you set the label's "CanGrow" property to false and if you are inside of a column group put the label inside of a rectangle and the set "CanGrow" to false.