Print comments and notes in Excel

If your worksheet contains threaded comments or notes, you can print them, either as they appear on the sheet or at the end of the sheet.

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.

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 arrow 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 At end of sheet.

    Note: In Excel for Office 365, you cannot print threaded comments as displayed on sheet. But you can print notes as displayed on sheet. See the next section on printing only notes in Excel for Office 365.

  5. Click Print Preview to see a preview of the comments and the notes. Optionally, go back to the worksheet and make any changes if necessary.

  6. Click Print. That takes you to the File tab and the Print category, where you can click Print again to print the document, or change settings such as page orientation before you 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.

  2. Select one of the following options to display and arrange the notes on the worksheet.

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

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

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

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

      Then, resize a note box by dragging its border. Move a note by dragging its handles on the sides or corners.

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

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

  4. Select the Sheet tab.

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

    Note: In Excel for Office 365, you cannot print only 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.

  6. Click Print Preview to see a preview of the notes. Optionally, go back to the worksheet and make any changes if necessary.

  7. Click Print. That takes you to the File tab and the Print category, where you can click Print again to print the document, or change settings such as page orientation before you print.

  1. Select the worksheet that contains the comments that you want to print.

  2. To print one or more comments as they appear on the worksheet, display and arrange the comments.

    • 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, click the Review tab and then click Show all Comments.

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

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

      Then, resize the comment box by dragging its border. Move a comment by dragging its handles on the sides or corners.

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

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

  4. Select the Sheet tab.

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

  6. On the Sheet tab, pick an option under Comments

  7. Click Print Preview to see a preview of the comments. Optionally, go back to the worksheet and make any changes if necessary.

  8. Click Print. That takes you to the File tab and the Print category, where you can click Print again to print the document, or change settings such as page orientation before you 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 cannot print threaded comments as displayed on sheet. But you can print notes as displayed on 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.

  2. Select one of the following options to display and arrange the notes on the worksheet.

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

    • To display all notes, click the Review tab, and click Notes > Show All Notes.

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

      Then, resize a note box by dragging its border. Move a note by dragging its handles on the sides or corners.

  3. On the File menu, click Page Setup.

  4. Select the Sheet tab.

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

    Note: In Excel for Office 365 for Mac, you cannot print only 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 for Mac.

  6. Click Print.

  1. Select the worksheet that contains the comments that you want to print.

  2. To print one or more comments as they appear on the worksheet, display and arrange the comments.

    • 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, click the Review tab and then click Show all Comments.

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

      Then, resize a note box by dragging its border. Move a note by dragging its handles on the sides or corners.

  3. On the File menu, click Page Setup.

  4. Select the Sheet tab.

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

  6. 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.

×