Paste comments to other cells in Excel
Quick and easy way to paste comments from one cell to other cells
To paste comments from one cell to other cells, simply copy the cell containing the comments, by pressing Clt+C.
Then go to the cell (or range of cells) to paste into, and right-click to select the “paste special” option.
In paste special window select “comments” and press ok.
This simple trick will save you the trouble and time involved in re-typing the same comments multiple times!