Print comments and notes in Excel

If your worksheet contains threaded comments or notes, you can print them.

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

  1. Select the worksheet that contains the comments that you want to print, then do one of the following:

    • To display an individual comment, right-click on the cell, and select Show/Hide Comments.

    • To display all comments in the worksheet, go to the Review tab > Show all Comments.

    • To move or resize any overlapping comments, click the border of the comment box so that its sizing handles appear.

      Click the edge of the comment box to move or resize it

      You can resize the comment box by dragging any of its sizing handles, or move it by selecting any part of its border, then drag it where you want.

  2. On the Page Layout tab, in the Page Setup group, click the flyout on the right to launch the Page Setup dialog.

    Click the arrow in the bottom right corner of the Page Setup group

  3. Select the Sheet tab.

  4. In the Comments box, choose either At end of sheet or As displayed on sheet.

    On the Sheet tab, pick an option under Comments

  5. Click Print, or Print Preview to see a preview of the comments.

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. Select the worksheet that contains the threaded comments and notes that you want to print.

  2. On the Page Layout tab, in the Page Setup group, click the flyout on the right to launch the Page Setup dialog.

    Click the arrow in the bottom right corner of the Page Setup group

  3. Select the Sheet tab.

  4. In the Comments box, click At end of sheet.

    Note: In Excel for Office 365, you can't print threaded comments as they're displayed on a worksheet, but you can print notes. See the next section on printing notes in Excel for Office 365.

  5. Click Print, or Print Preview to see a preview of the comments and the notes.

You can print notes the way they appear on the sheet.

  1. Select the worksheet that contains the notes that you want to print, then do one of the following:

    • To display an individual note, right-click the cell and click Show/Hide Note.

    • To display all notes, go to the Review tab > Notes > Show All Notes.

    • To move or resize any overlapping notes, click the border of the note box so that its sizing handles appear.

      Click the edge of the comment box to move or resize it

      You can resize the note by dragging any of its sizing handles, or move it by selecting any part of its border, then drag it where you want.

  2. On the Page Layout tab, in the Page Setup group, click the flyout on the right to open the Page Setup dialog box.

    Click the arrow in the bottom right corner of the Page Setup group

  3. Select the Sheet tab.

  4. In the Comments box, click As displayed on sheet (legacy).

    Note: In Excel for Office 365, you can't print just notes at the end of the sheet. However, you can print both threaded comments and notes at the end of the sheet. See the previous section on printing threaded comments and notes in Excel for Office 365.

  5. Click Print, or Print Preview to see a preview of the notes.

  1. Select the worksheet that contains the comments that you want to print, then do one of the following:

    • To display an individual comment, right-click on the cell right-click the cell and select Show/Hide Comments.

    • To display all comments in the worksheet, go to the Review tab > Show all Comments.

    • To move or resize any overlapping comments, right-click and select Edit Comment, and the border of the comment box will display sizing handles.

      You can resize a comment by dragging any of its sizing handles, or move it by selecting any of its borders, then drag it where you want .

  2. On the File menu, click Page Setup.

  3. Select the Sheet tab.

  4. In the Comments box, choose either At end of sheet or As displayed on sheet.

  5. Click Print.

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. Select the worksheet that contains the threaded comments and notes that you want to print.

  2. On the File menu, click Page Setup.

  3. Select the Sheet tab.

  4. In the Comments box, click At end of sheet.

    Note: In Excel for Office 365 for Mac, you can't print threaded comments as they're displayed on a sheet. But you can print notes as they're displayed on a sheet. See the next section on printing only notes in Excel for Office 365 for Mac.

  5. Click Print.

You can print notes the way they appear on the sheet.

  1. Select the worksheet that contains the notes that you want to print, then do one of the following:

    • To display an individual note, right-click the cell and click Show/Hide Note.

    • To display all notes, go to the Review tab > Notes > Show All Notes.

    • To move and resize any overlapping notes, right-click and select Edit Note, and the border of the note box will display sizing handles.

      You can resize a note box by dragging any of its sizing handles, or move it by selecting any of its borders, then drag it where you want .

  2. On the File menu, click Page Setup.

  3. Select the Sheet tab.

  4. In the Comments box, click As displayed on sheet (legacy).

    Note: In Excel for Office 365 for Mac, you can't print just notes at the end of a sheet. However, you can print both threaded comments and notes at the end of a sheet. See the previous section on printing threaded comments and notes in Excel for Office 365 for Mac.

  5. Click Print.

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.

See Also

Insert comments and notes in Excel

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.

×