Document Editing Problems

How to Copy Comments or Notes to Other Excel Cells

Muhammad TalhaMuhammad Talha Nov 20, 2026 870 views

Question details

The user wants to copy comments or notes from Excel cells to other cells without copying their contents or formatting.

How to Copy Comments or Notes to Other Excel Cells
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.
Before you start

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.

Solution 1Recommended

Copy Excel Comments or Notes with Paste Special

Use Paste Special to transfer annotations without copying the source cell values or formatting.

1
Copy the source cells

Select the cell or range containing the comments or notes, then choose Home > Copy or press Ctrl+C on Windows.

2
Select the destination

Click the destination cell, or select the destination range for the copied annotations.

3
Open Paste Special

Go to Home > Paste > Paste Special.

4
Paste the annotations

Select Comments, Notes, or Comments and Notes, depending on the option shown in your Excel version, and click OK.

Copy Excel Comments or Notes with Paste Special
Options vary by version: Excel distinguishes threaded comments from notes. If your Paste Special dialog does not offer the option you need, check Microsoft's guidance for copying threaded comments or notes in your Excel version.
Work with spreadsheet notes

Copy Spreadsheet Notes in WPS Office

Use Paste Special in WPS Spreadsheets to copy cell notes without copying the source values or formatting.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Copy the source: Select the cell or range containing the notes and choose Home > Copy.
  3. 3. Choose a destination: Click the cell or select the range where you want to paste the notes.
  4. 4. Paste comments: Choose Home > Paste > Paste Special, select the Comments option, and confirm. Option names may vary by WPS version.
Copy cell notes to other locations with Paste SpecialOpen and edit Microsoft Excel XLS and XLSX filesWork with spreadsheets in a familiar interfaceUse WPS Office for free
QA img-9

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.