Hello, I have a protected worksheet that does not allow users to manually edit a merged cell width/height. Occasionally, a user needs to enter more text than the cell is currently formatted to display. This doesn't happen often though. The user needs all the text to appear when she prints the worksheet, but when she prints, only the text showing in the cell will print.

I've tried unprotecting the worksheet and selecting Autofit Row Height for the cell, but that didn't work. I tried giving her permissions in the Allow Users to Edit Ranges, but that didn't work either. I did protect the worksheet again after selecting each of these options.

Any thoughts?