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 holidays) but I would like an easier method. I tried dragging the attachment point of the linked Note, but that doesn't work.
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.
