by Jackie Kiadii – Atlanta-based Excel Trainer
Question:
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?
Answer:
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.
4 – Select Comments, then click OK.
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.
Click to Grab Your Excel Ebook – Free!
