Document Editing Problems

How to Copy Excel Comments to Multiple Cells and Worksheets

Amos GikundaAmos Gikunda Nov 10, 2026 870 views

Question details

The user wants to know how to duplicate a legacy comment (note) to multiple cells simultaneously and across multiple worksheets without copying the cell data.

How to Copy Excel Comments to Multiple Cells and Worksheets
Product
Microsoft Excel
Device & OS
not provided
Scenario
Applying the same comment or note to various cells across one or multiple sheets to save time and avoid manual re-entry.
Observed behavior
Standard copy-pasting overwrites cell data, and the Paste Special feature only applies comments to the active worksheet, requiring a workaround for multiple sheets.
Before you start

Ensure you are working with legacy comments (now labeled as 'Notes' in newer Excel versions) rather than modern threaded comments, as the duplication methods and VBA objects for these differ.

Solution 1Recommended

Copy Comments to Multiple Cells on the Same Worksheet

Use the Paste Special feature to apply a comment to a range of cells without altering their existing data or formatting.

This built-in Excel feature is the fastest way to duplicate comments within a single active sheet.

1
Copy the source cell

Click on the cell containing the original comment and press Ctrl+C, or right-click and select 'Copy'.

2
Select the destination range

Highlight the range of cells where you want the comment to appear.

3
Open Paste Special

Right-click the selected range and choose 'Paste Special' from the context menu.

4
Paste the comments

In the Paste Special dialog box, select the 'Comments' (or 'Comments and Notes') option and click 'OK'.

Copy Comments to Multiple Cells on the Same Worksheet

Copy Comments to Multiple Cells Easily in WPS Spreadsheet

WPS Spreadsheet offers a highly compatible and intuitive interface for managing your data. You can easily copy and paste comments to multiple cells using the Paste Special feature, exactly as you would in Microsoft Excel.

  1. 1. Copy the comment: Open your workbook in WPS Spreadsheet, right-click the cell with the comment, and select 'Copy'.
  2. 2. Select target cells: Highlight the destination cells where you want the comment applied.
  3. 3. Use Paste Special: Right-click the selected area, choose 'Paste Special', check the 'Comments' option, and click 'OK'.
Free and lightweight alternative to Microsoft ExcelFully compatible with Excel .xls and .xlsx formatsSupports Paste Special functionality for comments and notesFamiliar user interface for a seamless transition
QA img-9

Frequently Asked Questions

What is the difference between comments and notes in recent Excel versions?

In newer versions of Excel, 'Comments' refer to threaded conversations meant for user collaboration, while the traditional sticky-note style indicators are now called 'Notes'. Paste Special and legacy VBA macros generally apply to these Notes.

Can I group sheets to paste comments across multiple worksheets?

Unfortunately, if you group worksheets and attempt to use Paste Special > Comments, Excel will only apply the comments to the active worksheet. This is why a VBA macro is required to perform the action across multiple sheets.

Will pasting comments overwrite the existing data in my target cells?

No. As long as you strictly use the 'Paste Special > Comments' option, only the comment box and its text will be transferred. The numerical data, text, or formulas in the destination cells will remain completely unchanged.