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 Professional Tech blogger, Editor and Writer who talks 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
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
How do you copy the comment to the cell value?? This only pastes it as another comment, which still cannot be manipulated. Thanks
Vince
Leave your response!
Subscription
Follow Us
Monthly Archives
Topics
What others are Saying ?