Home » Tips N Tricks » Office Tips » How to copy only comments from a cell in Excel 2010 / 2007

How to copy only comments from a cell in Excel 2010 / 2007

This 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 choose Paste Special  again which is at the bottom after other paste options.
  • Select only comments and click ok.

Paste Special in Office Excel

 

Office Excel Paste 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.


About Ashish Mohta

A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. His expertise are in Windows 7, Microsoft Office, Software, Mobile Apps and Video Posts.