Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Comments
How do I paste value a cell without loosing the cell comment?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Special Comments
To copy a value and comment from cell A to another cell B, you can do it
in two pastes: Copy cell A Select cell B, and choose EditPaste Special Click on Values, click OK With cell B still selected, choose EditPaste Special Click on Comment, click OK Note: this will overwrite the comment in cell B, if it has one already. elliobr wrote: How do I paste value a cell without loosing the cell comment? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
No "Comments" in Paste Special | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |