How to Copy Comments or Notes to Other Excel Cells
Question details
The user wants to copy comments or notes from Excel cells to other cells without copying their contents or formatting.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs to reuse comments or notes in another cell or range of a worksheet.
- Observed behavior
- The destination cells should receive the comments or notes while retaining their existing values and formatting.
Identify the source cells and destination cells, and check whether the annotations are notes or threaded comments. In newer Excel versions, traditional comments are called notes, while threaded comments support conversations.
Copy Excel Comments or Notes with Paste Special
Use Paste Special to transfer annotations without copying the source cell values or formatting.
Select the cell or range containing the comments or notes, then choose Home > Copy or press Ctrl+C on Windows.
Click the destination cell, or select the destination range for the copied annotations.
Go to Home > Paste > Paste Special.
Select Comments, Notes, or Comments and Notes, depending on the option shown in your Excel version, and click OK.

Copy Spreadsheet Notes in WPS Office
Use Paste Special in WPS Spreadsheets to copy cell notes without copying the source values or formatting.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Copy the source: Select the cell or range containing the notes and choose Home > Copy.
- 3. Choose a destination: Click the cell or select the range where you want to paste the notes.
- 4. Paste comments: Choose Home > Paste > Paste Special, select the Comments option, and confirm. Option names may vary by WPS version.

Frequently Asked Questions
Will Paste Special overwrite the destination cell's value?
Selecting Comments, Notes, or Comments and Notes in Paste Special transfers annotations rather than source values or formatting.
What is the difference between a comment and a note in newer Excel versions?
Notes are the traditional cell annotations formerly called comments. Threaded comments are designed for conversations and replies.
Can I copy notes from several cells at once?
Yes. Select the source range, copy it, select the destination, and use Home > Paste > Paste Special to paste comments or notes.
What if I don't see a Comments or Notes option in Paste Special?
Paste Special options vary by Excel version and platform. Check Microsoft's guidance for copying threaded comments or notes in your version.




