Print comments on a worksheet

If your worksheet contains comments like the one shown here, you can print them, either as they appear on the sheet or at the end of the sheet.

Example of a comment in a worksheet

To print comments
  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 the cell containing the comment, and then click Show/Hide Comments on the shortcut menu.

    • To display all comments in the worksheet, on the Review tab, in the Comments group, click Show All Comments.

      Show All Comments option on the Review tab

    • 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 a 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 As displayed on sheet or At end of sheet.

    On the Sheet tab, pick an option under Comments

  6. At the bottom of the dialog box, 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.

For more information about printing, see Print a worksheet or workbook.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!