Insert comments and notes in Excel

You can add comments to cells. When a cell has a comment, an indicator appears in the corner of the cell. When you rest the pointer on the cell, the comment appears.

Note: July 25, 2018: Threaded comments is a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize this feature over the next several months. When it's ready, we'll release it to all Office Insiders, and Office 365 subscribers.

  1. Right-click the cell and then click New Comment.

  2. Type your comment.

  3. Click the Post button (or press Ctrl+Enter).

  4. If other people have something to add, they can right-click the cell and choose Reply to Comment.

If you need to edit a threaded comment, rest your cursor over the cell. Then rest your cursor over the comment text itself, and click Edit.

If you need to delete a threaded comment, right-click the cell and then click Delete Comment.

If you need to delete a reply, rest your cursor over the cell. Then rest your cursor over the reply text itself, and click Delete.

  1. Right-click the cell and then click Insert Comment (or press Shift+F2). If you're using Excel for Office 365, right-click the cell and choose New Note.

  2. Type your annotation text.

  3. Click outside the box.

If you need to edit the note, right-click the cell, and then click Edit Comment. If you're using Excel for Office 365, right-click the cell and choose Edit Note

If you need to delete the note, right-click the cell and choose Delete Comment. If you're using Excel for Office 365, right-click the cell and choose Delete Note.

In Excel for Office 365, there are two kinds of comments to choose from: comments and notes. For more information, see the article, Threaded comments and notes.

  1. Select the cell or cells that contain the comments that you want to copy.

  2. Press Ctrl+C.

  3. On the Home tab, click the arrow below Paste, and then click Paste Special.

  4. In the Paste Special dialog box, under Paste, click Comments, and then click OK.

  5. To cancel the moving border, click another cell or press Esc.

Notes: 

  • Do not press Enter after you click OK. If you do, cell contents are copied to the paste area in addition to the comment.

  • Copied comments replace any existing comments in the destination area.

By default, Excel displays an indicator when a cell contains a comment or a note. You can control how Excel displays comments and indicators in cells by changing the default settings to always show or hide the comments.

  1. Click the File tab, then click Options. In Excel 2007: click the Microsoft Office Button Office button image , and then click Excel Options.

  2. In the Advanced category, under Display, do one of the following:

    • To hide both comments and indicators throughout the workbook, under For cells with comments, show, click No comments or indicators.

    • To show indicators but display comments only when you rest the pointer over their cells, under For cells with comments, show, click Indicators only, and comments on hover.

    • To always display both comments and indicators, under For cells with comments, show, click Comments and indicators. Note that in Excel for Office 365, this setting only applies to notes, not threaded comments.

Excel labels each threaded comment with the name of the person who is currently logged in with their account. This cannot be changed by typing over it. However, notes are different. Excel labels notes by using a name that you specify in the Options dialog box. The following procedure explains how to change the name that appears on notes, not threaded comments.

  1. Click the File tab and then click Options. In Excel 2007: click the Microsoft Office Button Office button image , and then click Excel Options.

  2. In the General category, under Personalize your copy of Microsoft Office, type a name in the User name box.

    Notes: 

    • If the User name box is empty, Excel automatically sets the value of the User name box to your user name, and uses that name for the label.

    • Although you can’t suppress note labels, you can remove labels from notes by deleting them.

See Also

Print comments and notes in Excel

Note: July 25, 2018: Threaded comments is a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize this feature over the next several months. When it's ready, we'll release it to all Office Insiders, and Office 365 subscribers.

  1. Right-click the cell and then click New Comment.

  2. Type your comment.

  3. Click the Post button (or press ⌘+Enter).

  4. If other people have something to add, they can right-click the cell and choose Reply to Comment.

If you need to edit a threaded comment, rest your cursor over the cell. Then rest your cursor over the comment text itself, and click Edit.

If you need to delete a threaded comment, right-click the cell and then click Delete Comment.

If you need to delete a reply, rest your cursor over the cell. Then rest your cursor over the reply text itself, and click Delete.

  1. Right-click the cell and then click Insert Comment

  2. Type your annotation text.

  3. Click outside the box.

If you need to edit the note, right-click the cell, and then click Edit Comment. If you're using Excel for Office 365 for Mac, right-click the cell and choose Edit Note.

If you need to delete the note, right-click the cell and choose Delete Comment. If you're using Excel for Office 365 for Mac, right-click the cell and choose Delete Note.

In Excel, there are two kinds of comments to choose from: comments and notes. For more information, see the article, Threaded comments and notes.

  1. Select the cell or cells that contain the comments that you want to copy.

  2. Press ⌘+C.

  3. On the Home tab, click the arrow below Paste, and then click Paste Special.

  4. In the Paste Special dialog box, under Paste, click Comments, and then click OK.

  5. To cancel the moving border, click another cell or press Esc.

Note: Copied comments replace any existing comments in the destination area.

By default, Excel for Mac displays an indicator when a cell contains a comment or a note. You can control how Excel displays comments and indicators in cells by changing the default settings to always show or hide the comments.

  1. Click Excel > Preferences > View (under Authoring).

  2. In the View dialog box, under For Cells with Comments, Show, do one of the following:

    • To hide both comments and indicators throughout the workbook, click No comments or indicators.

    • To show indicators but display comments only when you rest the pointer over their cells, click Indicators only, and comments on rollover.

    • To always display both comments and indicators, click Comments and indicators.

Excel labels each threaded comment with the name of the person who is currently logged in with their account. This cannot be changed by typing over it. However, notes are different. Excel labels notes by using a name that you specify in the Options dialog box. The following procedure explains how to change the name that appears on notes, not threaded comments.

  1. Click Excel > Preferences > General.

  2. In the General dialog box, under Personalize , type a name in the User name box.

    Notes: 

    • If the User name box is empty, Excel automatically sets the value of the User name box to your user name, and uses that name for the label.

    • Although you can’t suppress note labels, you can remove labels from notes by deleting them.

See Also

Print comments and notes in Excel

  1. Right-click the cell and then click New Comment.

  2. In the Comments pane, type your comment. You can even address the comment to a specific user by typing the @ symbol followed by the user name, or select a user from the dropdown list that appears.

  3. Click the Post button (or press Ctrl+Enter).

  4. If other people have something to add, they can right-click the cell and select New Reply.

If you need to edit a threaded comment, click on the cell and then click the Show comment icon, and then hover on comment you want to edit, and then click Edit.

If you need to delete a threaded comment, right-click the cell and then click Delete Comment.

If you need to delete a reply, click on the cell and then click the Show comment icon, and then hover on comment you want to delete, and then click Delete.

Note: When you copy and paste threaded comments to other cells, Excel Online will also paste the cell values.

  1. Select the cell or cells that contain the comments that you want to copy.

  2. Press Ctrl+C.

  3. Select the empty cells and press Ctrl + V.

Note: Copied comments replace any existing comments in the destination area.

  1. In an Excel workbook, tap in the worksheet.

  2. Tap Insert.

  3. Tap Comment.

    In Excel for Android devices:

    Add a comment in Excel for Android

    In Excel for iPad:

    Add a comment in Excel for iPad

    In Excel Mobile for Windows 10:

    Add a comment in Excel Mobile for Windows 10

  4. Type your comment.

  5. Tap outside the comment box to stop commenting.

  6. To view the comment, tap the comment in the workbook.

    To delete a comment, tap the comment icon and then tap X.

  1. Tap the Edit icon Tap to see the ribbon on your iPhone or Android phone. Tap More Tap to see the ribbon on your Windows phone.

  2. Tap Home, and then tap Review.

    Tap Review

  3. To add a comment, tap New Comment on your iPhone or Comment on your Android or Windows phone, type your comment, and then tap Done.

  4. To view or edit existing comments, tap the comment.

    To edit a comment, tap the Edit comment icon.

    Add a comment

    To delete a comment, tap the Delete comment icon.

    Delete comment

    When you are done with your changes, close the comment box by tapping the down arrow on your iPhone or the X on your Android or Windows phone.

  1. In an Excel workbook, tap in the worksheet.

  2. Tap Insert.

  3. Tap Comment.

    In Excel for Android devices:

    Add a comment in Excel for Android

    In Excel for iPad:

    Add a comment in Excel for iPad

    In Excel Mobile for Windows 10:

    Add a comment in Excel Mobile for Windows 10

  4. Type your comment.

  5. Tap outside the comment box to stop commenting.

  6. To view the comment, tap the comment in the workbook.

    To delete a comment, tap the comment icon and then tap X.

  1. Tap the Edit icon Tap to see the ribbon on your iPhone or Android phone. Tap More Tap to see the ribbon on your Windows phone.

  2. Tap Home, and then tap Review.

    Tap Review

  3. To add a comment, tap New Comment on your iPhone or Comment on your Android or Windows phone, type your comment, and then tap Done.

  4. To view or edit existing comments, tap the comment.

    To edit a comment, tap the Edit comment icon.

    Add a comment

    To delete a comment, tap the Delete comment icon.

    Delete comment

    When you are done with your changes, close the comment box by tapping the down arrow on your iPhone or the X on your Android or Windows phone.

  1. In an Excel workbook, tap in the worksheet.

  2. Tap Insert.

  3. Tap Comment.

    In Excel for Android devices:

    Add a comment in Excel for Android

    In Excel for iPad:

    Add a comment in Excel for iPad

    In Excel Mobile for Windows 10:

    Add a comment in Excel Mobile for Windows 10

  4. Type your comment.

  5. Tap outside the comment box to stop commenting.

  6. To view the comment, tap the comment in the workbook.

    To delete a comment, tap the comment icon and then tap X.

  1. Tap the Edit icon Tap to see the ribbon on your iPhone or Android phone. Tap More Tap to see the ribbon on your Windows phone.

  2. Tap Home, and then tap Review.

    Tap Review

  3. To add a comment, tap New Comment on your iPhone or Comment on your Android or Windows phone, type your comment, and then tap Done.

  4. To view or edit existing comments, tap the comment.

    To edit a comment, tap the Edit comment icon.

    Add a comment

    To delete a comment, tap the Delete comment icon.

    Delete comment

    When you are done with your changes, close the comment box by tapping the down arrow on your iPhone or the X on your Android or Windows phone.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×