Hi, I’m keeping track of a large online movie tournament in Excel, a program I’m not all that familiar with. I keep information that’s important but would be intrusive in Comments, but I’m finding that that comes with its own problems.
First, I’ll get a Comment all set, then when I go back to it later, and click on “Edit Comment” or “Show Comment” it’ll show up elsewhere on the worksheet instead of right next to the place it belongs. There’s a straight line from that cell to the comment, and often it’s very long. I have to physically move it back to the cell where it belongs, but it moves again the next time I go to it. That’s happened to all my Comments on one sheet. It’s very annoying and time consuming to deal with, and I have no idea what I did to make that happen in the first place. I didn’t move a Comment that would have affected the others. Is there any way to “freeze” the comments so they don’t go jumping around?
I aso want to freeze the size of the Comment, because the Comment box will change, sometimes to a thin sliver, for no reason at all.
The other thing I haven’t figured out is the Sort. I couldn’t find a way to sort by Comment, so I could see at a glance which cells have Comments and which don’t.
Oh and, Search, trying to search for a specific phrase when I can’t remember which cell I put it in. Is that possible?
Any suggestions? I appreciate your thoughts.