Forum Discussion
Can't edit a note - a line appears
I have been having the same problem.
I create a note, then try to edit it by right clicking the cell. I does not open the note for editing.
I save the file, reopen it, try to edit the note again and it starts working.
This is a very frustrating bug.
Thanks for the suggestion Stephen but no luck. Still just a line leading from the cell. When I create a new note in a cell I get a line but no box to make the note. The note will not open for editing. Saving and reopening the file makes no difference. Just a line. BTW I am using Excel on a Mac PC are you?
DavidC360 - I'd been having this same issue. I was finally able to resolve it by:
1 - unhiding all rows/columns
2 - right click on the cell with the note and select "Edit Note"
3 - follow the line to the note box and click/drag on one of the edges to make it bigger. For me - all the note boxes were at the top of the spreadsheet and the note boxes had been collapsed so all I could see was the six little squares that form the outline of the note box.
4 - when big enough to read it. click/drag on the note box again and move it closer to the cell that the note applies to
I am guessing MSFT screwed something up with a recent upgrade and our notes boxes were all minimized and moved to the top of the spreadsheet. Good luck. Hope this helps.
- Thanks for the suggestion but it did not work for me. Big MSFT failure been going on for almost two years with no fix. Shameful behaviour.
