Home > Skills > Comments > Basics Excel Comments - BasicsAdd Excel pop-up comments to worksheets cells, to explain the contents, or to offer tips to users. Different ways to print comments - on the sheet, with triangles, with numbers. Note: In Excel 365, these pop-up comments are called "Notes", and the Comments feature creates new-style Threaded Comments. Some of old-style (legacy) comment features are not available in Threaded Comments. |
Copy CommentsInstead of creating new comments in Excel, you can copy and paste existing comments to a new location. To copy and paste cell comments, without the cell contents, follow these steps:
Comments from the copied cells are pasted in the new location. Note: If multiple cells in a range were copied and pasted, the comments are pasted into cells in the same relative locations |
Printing Excel CommentsYou can print Excel comments in 2 built-in ways:
Or, use a macro to print comments with a triangle comment indicator, or a small number, at the top right corner of the cell (details for this are in the next section) This short video shows the steps for the two built-in ways of printing worksheet comments , and there are written steps below the video |
Print comments as displayedTo print Excel comments as they are displayed on the sheet, follow these steps:
Note: The open comments are printed with the worksheet cell contents, but the red triangles in comment cells are NOT printed. Print comments at end of worksheetTo print Excel comments at the end of the worksheet, follow these steps:
|
Print Comments with Triangles or NumbersWhen you print a worksheet that contains comments, the comment indicators (little red triangles) are not visible. Unless the comments are shown, there is no indication of which cells contain comments.
As a workaround, you can use macros to mark the comment cells, before you print the worksheet. Use one the macros linked below, to mark the comments cells with:
The screenshots below show what each marker looks like. Add Triangle Shapes for Comment Cell PrintingBefore you print a worksheet, you can use a macro, to draw a triangle AutoShapes over the comment indicators, at the upper-right corner of the comment cell. You can get the sample file with this macro, in the Download section below. For the written instructions, go to the Comment Macros page. |
Add Numbers in Comment CellsAnother option for printing comments, is to use Excel VBA macros that:
You can get the sample file with this macro, in the Download section below. For the written instructions, go to the Comment Macros page. |
Download the Sample Files
|
Related Tutorials |
Last updated: December 11, 2022 1:42 PM