I have a workbook, used by multiple users, with merged cells. The sections with the merged cells require typing anywhere from a few words to paragraphs of information. The text wraps, but I am looking for a way to have the cells auto-expand based on the amount of information that is entered. I have heard this can't be done, but I can't believe that's true. Any suggestions out there?

Thanks,
Amy