How to copy only comments from a cell in Excel 2007
his is a very handy trick if you just want to copy comment from already filled in and formatted cell to another cell in excel without additional formatting. The fist step is to copy the cell completely. Then select the cell where you would like to paste the comment. Now right click and click paste special and select only comments.
‘
Thats it. You would see just the comments getting copied. So if you have need like this dont forget the magic paste special.
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
 |  |  |  |  |  |  |
Posted on 15th September 2008 by Ashish Mohta , A tech blogger who writes about solving day to day problems of people who use computer. He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by Ashish Mohta | Connect with me @
Twitter |
Linkedin |
Facebook |
Stumble
| Need more help? Ask your Questions at our Support Center
Free Email Subscription
thanks Ashish. this library are applied without...
Dear Sir/Madam,
I am working for a call center and we use Excel to add the details of all the work done during the shift. We also get downtime for break and meetings and we have to add some comments for what we have taken the downtime for.(Eg, if we have gone for break, and we take 50 minutes downtime. So we have to add a comment saying that, ‘gone for break’). We have total 180 agents who are using this Excel sheet. Is there any formula which can copy only the comments of the agents on different worksheet? I even know that I can do it by using paste special, but opening the Excel sheet of 180 agents and copying the cell which has the comment is not possible.
My email id is: georgeakh@gmail.com
I hope to hear from you soon.
Regards
George Akhade
Leave your response!