How to Copy Excel Comments to Multiple Cells and Worksheets
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.

- 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.
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.
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.
Click on the cell containing the original comment and press Ctrl+C, or right-click and select 'Copy'.
Highlight the range of cells where you want the comment to appear.
Right-click the selected range and choose 'Paste Special' from the context menu.
In the Paste Special dialog box, select the 'Comments' (or 'Comments and Notes') option and click 'OK'.

Copy Comments Across Multiple Worksheets Using VBA
Since Excel does not support pasting comments to multiple worksheets simultaneously via the menu, use a simple VBA macro to automate the task.
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. Copy the comment: Open your workbook in WPS Spreadsheet, right-click the cell with the comment, and select 'Copy'.
- 2. Select target cells: Highlight the destination cells where you want the comment applied.
- 3. Use Paste Special: Right-click the selected area, choose 'Paste Special', check the 'Comments' option, and click 'OK'.

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.




