Print comments

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

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

  2. To print the comments in place on the worksheet, display them by doing one of the following:

    • To display an individual comment, click the cell that contains the comment, and then on the Review tab, in the Comments group, click Show/Hide Comment.

      Tip   You can also right-click the cell and then click Show/Hide Comments on the shortcut menu.

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

      Excel Ribbon Image

      Tip   You can move and resize any overlapping comments.

      How to move or resize comments

      1. Click the border of the comment box so that handles appear:

        Worksheet comment with sizing handles

      2. Do one or both of the following:

        • To move the comment, drag the border of the comment box.

        • To change the size, drag the handles on the sides and corners of the comment box.

  3. On the Page Layout tab, in the Page Setup group, click the dialog box launcher Button image next to Page Setup.

    Excel Ribbon Image

  4. On the Sheet tab, in the Comments box, click As displayed on sheet or At end of sheet.

  5. Click Print.

    Tip   To see how comments are printed, you can click Print Preview before you click Print.

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language