98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Comments
Comments
Resolved · Low Priority · Version 2007
Shelley has attended:
Excel Intermediate course
Comments
Is it possible to copy and paste comments into other cells instead of having to retype them?
RE: Comments - copying and pasting!!
Dear Shelley
Thank you for attending Excel Intermediate course. I hope you enjoyed the course and benefited from it.
It is possbile to copy the cell that has comment on and paste it to blank cell and the comment will get pasted along with the comments.
But if you want to paste only the comments on the cells that already have data then choose the cell taht has the comment you wish to copy.
Select all the cells that you wish to paste the comments
Right-click on any selecetd cell
Choose paste Special...
Choose Comments from the available options and press OK.
All the cells that you selected will have only the comments pasted.
I hope this helps in answering your query.
Please mark this post as resolved.
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Seeing named ranges as part of the zoomIf you have large areas of named ranges this works better. |