View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Comment Function

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.
--
Gary''s Student - gsnu200804


"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,