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善於秘訣
 |  |  |  |  |  |  |  |  |  |  |  |  |  |
Posted on 15th September 2008 by發布於2008年9月15號的 Ashish Mohta 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 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!離開你的答复！