Forum Discussion
Change line linked to Notes in Excel
I do a yearly calendar to standardize the mileage my co-workers submit. I put in Notes for specific days, memorable in history or holidays. Every year I manually change the line of the note (for the ...
notisaconed Probably the easiest way to transfer Comments and Notes from cell to cell is to use Copy / Paste Special > Comments and Notes. First, select the cell with the note you want to transfer and press Ctrl+C to copy it. Next, select the destination cell and press Ctrl+Alt+V to open the Paste Special dialog box (or go to Home > Paste > Paste Special on the Ribbon), then press C to select "Comments and Notes" and press Enter (or select it with the mouse and click OK).
Paste Special > Comments and Notes
Last, right-click on the original cell and select either Delete Comment or Delete Note to remove the original comment/note.