Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

This question already has an answer here:

I added comments to a bunch of cells. When I then sorted the cells, the comments did not follow their original cell and now was connected to the new cell. This is a massive problem and now my comments are all messed up.

This is the same problem that was brought up here, but was not answered. Google spreadsheet sorting messes up cell comments

Any ideas?

share|improve this question

marked as duplicate by Jacob Jan Tuinstra, Alex, Al E., jonsca Dec 14 '13 at 6:03

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
Can you share a doc with us? –  Jacob Jan Tuinstra May 22 '13 at 16:05
add comment

1 Answer 1

From what it looks like, the position of comments are absolute, that is, comments always stay at the row number/column number that you first assigned them to (however, if you cut and paste a data cell, the comment will follow along; if you copy and paste it, the comment will stay at its original position).

However, notes are attached to the actual data point, meaning that if the data point moves during a sorting operation, the note will move as well (in addition, a note will move if you cut and paste a data cell, and it will get duplicated if you copy and paste it).

That is, right now it seems like your best bet is to use notes instead of comments. If this is a non-starter, then it seems like you're out of luck.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.