
Or just click the cell and Use shortcut Ctrl + Alt + V.Īs you can see the new cell has the same link without even going to the edit comment option. Right click > Paste Special > Paste special. So First we do the obvious thing, to copy cell using Ctrl + C.

Here copying cell contains the link of exceltip website in comments. Basically copy and paste comments of one cell to another without editing any cell value. Here we have a cell and we need to copy the comments of the cell and paste the comments of the cell to the new cell as comment.

EXCEL FOR MAC COMMENT NOT SHOWING HOW TO
Let's understand how to use the function using an example. Learn more about Paste Special dialog box HereĪll of these might be confusing to understand.

For problems like these, we use Paste special method in Excel. I know it becomes hectic when you have many cells to copy and paste. First you need to edit comment, then copy comment, Go to other cell insert comment, then paste in the comment box. For example if a user wants to copy a cell comment in excel. Working on excel files with cell comments. In this article, we will learn How to copy and paste cell comments in Excel.
