comment boxes in excel not behaving correctly

Copper Contributor

I bought a new desktop Mac Catalina and new Office (16.41) last May to replace my old Mac + system. Since then a big spreadsheet in Excel, with hundreds of comment boxes, has been behaving erratically. Some comment boxes have changed sizes, some have text spilling over the edge of the box, others, upon opening "Edit comment" shoots the box off to another place in the spreadsheet.  For some the hovering over the cell to see the comment box doesn't work. For many the size of the box doesn't match the text, in some of these with a huge box containing a couple of sentences.  I've been fixing them one by one but have gone crazy doing so.  Anyone know a generic fix?  If so, please note that I'm a technological idiot and need super explicit instructions.  Many thanks!

0 Replies