Comment Function

[Chilired]

I created a spreadsheet (Excel 2003) that has multiple comments; when the
information is sorted the comments are seperated from the original text. Is
there a way to make the comments "stick" with the information once it is
sorted? By the way the sheet will be protected and placed on the web.

Working on a tight deadline would appreciate a reply asap.

Thanks,

 

[Gary''s Student]

The comments should stick to cells automatically. For example, say you enter
the numbers 1 th 9 in cells A1 thru A9 and insert a comment in A9.

If you now sort column A descending, the 9 will move to cell A1 and so will
the comment.

 

[Sheeloo]

Cooments do get sorted with the cell they are associated with if you have
used 'Insert Comment' option.

They do not move IF you have manually positioned them after choosing 'Show
Comments' option

 

[Chilired]

I have used comments before and never had an issue, however with this
spreadsheet I am encountering the problem of comments attaching to different
cells.

When using the auto filter function, inserted a comment for to B6, copied,
then Paste Special/Comment to the remaining cells in the sorted information.
When I use the auto filter again the information appears in all my cells
instead of the ones that selected in the sort. Any suggestions on what I am
doing incorrectly?

Thanks,

 

[Sheeloo]

This is different from what you had described earlier.

Anyway, choose Edit->Go To->Special->Visible Cells only and the Copy and do
Paste Special...

 

[Chilired]

You are correct, I thought about it late last night; that's why I repharsed
the request. The suggestion seems to be working thus far. Another question:


Once I select a cell, B2, the comment for that cell appears, however if I
move my the cursor, other comments not applicable to the current cell appear.
I only want the comment applicable for the selected cell to appear and
remain visible until another cell is selected. Is that possible?

 

[Sheeloo]

I don't think that is possible. You will see comments etc. belonging to the
current cell you are on while moving your cursor.