i am using a mac and have been exploring the use of worksheets on drawings and have found that though i am able to create multiple lines of text within a single cell using the 'option+return' keys. however, when i exit the active worksheet, the worksheet on my drawing does not reflect this. rather, it merges the two lines of text into one.
i have been able to get it to work if i typed the text in excel first and then copied it into a cell on my worksheet. but as soon as i make changes to the text, it reverts to the single line again on my drawing only.
would be great if the worksheet on drawing can reflect what i see in the active worksheet.
