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


"Chilired" wrote:

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" wrote:

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" wrote:

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,

"Chilired" wrote:

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,