How to copy only comments from a cell in Excel 2007如何只复制评论从一个细胞在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.他是一个非常方便的把戏，如果你只是想复制评论已经填补和格式化细胞到另一个细胞在Excel中没有额外的格式。 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.因此，如果您有需要这样不要忘记贴上特殊的魔力。
Tags:标签： copy comments复制评论 , ， excel 2007 tips Excel 2007中的提示 , ， excel tips善于秘诀
 |  |  |  |  |  |  |  |  |  |  |  |  |  |
Ashish Mohta Ashish Mohta is A tech blogger who writes about solving day to day problems of people who use computer.是A科技博客谁写了关于解决日常问题的人谁使用计算机。 He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by他在书中还对如何使用应用软件，如办公室，电脑提示，在线工具，浏览器和更多。 所有职位 Ashish Mohta Ashish Mohta | Connect with me @ |与我联系@ Twitter 叽叽喳喳 | | Linkedin LinkedIn的 | | Facebook 脸谱 | | Stumble 失败 | Need more help? |需要更多的帮助？ Ask your Questions at our 问问你的问题在我们的 Support Center 支援中心
Free Email Subscription
Leave your response!离开你的答复！