Before learning about how to copy a cell comment in another cell, we have to understand the comments i.e. what the comments are and how we can identify that this is a comment in Microsoft Excel 2010.
There are various ways to copy comments in excel i.e. through keyboard shortcuts or via VBA code; we will learn using keyboard shortcuts in this tutorial.
We use the Comment in Excel just for our remembrance and to inform someone else about what the cell contains. To add a comment in a cell, Excel provides the Insert Comment functionality. After inserting the comment, it shows with the little red triangles to indicate comments in cells comments.
To copy the cell comment from one cell to another cell, we will use the Paste Special option.
The Paste Special option is used for pasting only the cell contents (without formatting) or only the formatting (without the cell contents).
Let’s take an example and understand how we can copy the cell comment from one cell to another.
We have working hour’s calculator sheet in which we have inserted many comments to remind the time calculations for the users.
To copy the cell comment from one cell to another cell, follow below given steps:-
This is the way we can use the comment in one cell to another cell by copying the cell and using the Paste Special option in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.