Forum Discussion
notes attached to cells not visible, broken since last excel update (Office 365 on Mac)
Thanks for all the info, but here's what happened:
I clicked the icon "Show comments" in the Ribbon, and got a message in the sidebar pane: "There are no Comments in this file." This is not surprising, since I always use "New Note" rather than "Comment."
Then I went back and re-read a post from earlier in this thread: I selected the errant cell, then hit "Edit Note" in the ribbon. That brought up the callout line, terminating in an invisible note. At that point I was able to grab the "stem" line and stretch it open (sort of like pulling down a window shade), and voila! There was my Note. The problem I ran into previously was that simply clicking the affected cell brought up the "stem" line, but the instant I moved the Plus-shaped cursor out of the cell in an attempt to grab the stem line, the line disappeared! The way to evoke the stem line and make it stay on screen is to click "Edit Note" in the Ribbon.
So I eventually got there. Thanks to all for your help!!
Jim6373My issue is that "edit notes" does nothing on any cell in one particular column that has cells with notes. No stem lines, no notes appearing, no nothing. The column has different formatting on different rows -- it is not a consistently formatted column. The formatting is similar to adjacent columns that are not having this issue -- notes show fine in the adjacent columns. Very bizarre that this one column would not show notes when I click 'edit notes'.
The only way to see my notes in that column is to select "show/hide all notes", in which case the dozens of notes I have all appear at once in a jumbled mess. I have all updates installed and rebooting did not help.
- ButlerDE58Jun 08, 2022Copper Contributor
opieandy123456 I found that copying and pasting the cell to a blank cell, then cutting and pasting it back to the original cell allows me to edit after getting the symptoms you were having. Just a workaround, but better than closing and opening the file (which doesn't work for me anyway).