# Quick Excel Comments questions **URL:** \ **Category:** Factual Questions\ **Created:** [February 14, 2003, 6:07pm UTC](https://boards.straightdope.com/t/quick-excel-comments-questions/155101 "2003-02-14T18:07:21Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Equipoise](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/equipoise/32/151_2.png) [@Equipoise](https://boards.straightdope.com/u/Equipoise)\ **Post date:** [February 14, 2003, 6:07pm UTC](https://boards.straightdope.com/t/quick-excel-comments-questions/155101/1 "2003-02-14T18:07:21Z")
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. ---
**Author:** ![D\_Odds](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/d_odds/32/2882_2.png) [@D\_Odds](https://boards.straightdope.com/u/D_Odds)\ **Post date:** [February 14, 2003, 6:13pm UTC](https://boards.straightdope.com/t/quick-excel-comments-questions/155101/2 "2003-02-14T18:13:30Z")
This may or may not apply globally. For your sake, I hope it does, or at least with all new comments. 1. Go to _Edit Comment_. 2. Right click on frame of comment and choose _Format Comment_. 3. Go to the _Properties_ tab. 4. Choose _Don’t Move or Size with Cells_. Hope this helps. Good luck. ---
**Author:** ![Equipoise](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/equipoise/32/151_2.png) [@Equipoise](https://boards.straightdope.com/u/Equipoise)\ **Post date:** [February 14, 2003, 7:29pm UTC](https://boards.straightdope.com/t/quick-excel-comments-questions/155101/3 "2003-02-14T19:29:37Z")
> [@](#): > > \*Originally posted by D\_Odds \* > \*\*This may or may not apply globally. For your sake, I hope it does, or at least with all new comments. > > 1. Go to _Edit Comment_. > 2. Right click on frame of comment and choose _Format Comment_. > 3. Go to the _Properties_ tab. > 4. Choose _Don’t Move or Size with Cells_. > > Hope this helps. Good luck. \*\* Thank you, but hmmm. I went to a cell with a comment, right clicked, and the comment, as expected, jumped several columns to the right. I positioned the cursor on the comment so that when I right clicked the _Format Comment_ option was visible, clicked that, got the multi-tabbed box, clicked _Properties_, and found that the _Don’t Move or Size with Cells_ radio button was already selected. I feel like a first-grader (as indeed I am wrt Excel knowledge), but what do these things mean? _Move and size with cells_, _Move but don’t size with cells_, _Don’t move or size with cells_? I feel they should be (are) obvious, but I’m not getting it. Thank you very much for taking the time to answer. ---
**Author:** ![Equipoise](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/equipoise/32/151_2.png) [@Equipoise](https://boards.straightdope.com/u/Equipoise)\ **Post date:** [February 14, 2003, 7:32pm UTC](https://boards.straightdope.com/t/quick-excel-comments-questions/155101/4 "2003-02-14T19:32:52Z")
Note to self: Preview preview preview.