Ask Jackie: How do I copy and paste a cell’s comments? Excel Tip by @learntech

Untitled Document

by Jackie Kiadii – Atlanta-based Excel Trainer


This question came up in a recent Excel for Peak Performers course.

I have a comment in one cell that applies to many cells. I really do not want to type the same comment 50 or so times. Since the data in each cell is different, a simple copy and paste won’t work. Any suggestions?


Yes, there is a way to copy and paste just a comment.  The process, while undocumented, is quick and easy.

1 – Copy the cell that contains your comment.

2 – Select the cells you want to paste the comment into. Remember you can use your CTRL key to select non-continguous cells.

3 – Right-click the cells and Left-click Paste Special.

Excel Tutorial - Paste Special


4 – Select Comments, then click OK.

Excel Paste Special Comments


As promised, it is very easy to copy and paste comments.

I’m always thankful for my students’ questions. Not only am I thrilled to help them solve their work problems, but they supply great fodder for this blog!

About the Author

Jackie Kiadii is an Information Technology professional with a degree in Computer Information Systems. She learned to program with Visual Basic over 20 years ago, and has developed the following Advanced-level Excel courses: Painless Pivot Tables ™, and Jump Start Excel Macros/VBA™, and Excel’s Best Functions – from A to Z™. Her company also offers Excel 2007, 2010 and 2013: Certification Prep, Basic through Advanced,

Need onsite group training? Call 770.498.7333 or email us. Our courses can be customized to your needs. Jackie has provided software training for employees of The Coca-Cola Company, Emory University, Novelis, and more. This training is available for groups of 4 or more students.

Atlanta Computer Training on Facebook Atlanta Computer Training - LinkedIn Software Tips on Twitter

Click to Grab Your Excel Ebook – Free!

Get the free Excel ebook

12 Tips to Empower Excel Users



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>