View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pyrite Pyrite is offline
external usenet poster
 
Posts: 78
Default Paste Special Comments

I'm not sure which you are asking so I will explain both.

If you want to copy the value in a cell to another cell and also copy the
comment then a simple copy and paste will do that.

If you want to copy a value from another cell into a cell WITH a comment but
dont want to lose that comment i.e. you have the value 25 in cell A2 and a
comment and you want to copy the value 30 from cell C2 into A2 without losing
the comment. You just need to copy the cell you want the value from and then
select Edit - Paste Special - Value and this will paste the value into the
cell and keep the comment.

Hope that helps.

"elliobr" wrote:

How do I paste value a cell without loosing the cell comment?