Print Comments in Excel 2007

When you print an Excel worksheet, you can also print all the comments that have been added to the sheet.

You can print the Excel comments the way they appear as pop-ups on the worksheet, or print all the comments at the end of the worksheet.

If you’re using an older version of Excel, there are details here — Printing Comments in Excel 2003.

Print the Comments as Displayed

When printing Excel comments as displayed, you can either show all the comments, or just show one or more comments that you want to print.

To show all the comments, on the Ribbon’s Review tab, click Show All Comments.

Show All Comments
Show All Comments

Show Specific Comment

To show a specific comment, select a cell that contains a comment. Then, on the Ribbon’s Review tab, click Show/Hide Comment.

CommentsShowHide

Arrange Comments for Printing

If necessary, rearrange the comments, so they don’t overlap, or cover the data.

Arrange Comments for Printing
Arrange Comments for Printing

Page Setup Dialog Box

Then, on the Ribbon’s Page Layout tab, click the More button for Sheet Options

RibbonSheetOptions

In the Page Setup dialog box, on the Sheet tab, select As Displayed on Sheet from the Comments drop down.

Page Setup Dialog Box
Page Setup Dialog Box

Quick Check With Print Preview

If you want to see how the comments will look when printed, click Print Preview

CommentsPreview

Click OK to close the Page Setup dialog box.

Print Comments at the End

Instead of printing the Excel comments as displayed, you can print them at the end of the worksheet.

On the Ribbon’s Page Layout tab, click the More button for Sheet Options

RibbonSheetOptions

In the Page Setup dialog box, on the Sheet tab, select As Displayed on Sheet from the Comments drop down.

CommentsPrintEnd

If you want to see how the comments will look when printed, click Print Preview. The comments and their addresses will appear on a separate sheet, at the end of the worksheet’s data.

CommentsPreviewEnd

Click OK to close the Page Setup dialog box.

Watch the Video

This Excel Quick Tips video shows how to display all the worksheet comments, and then print the worksheet with the comments displayed.

____________

9 thoughts on “Print Comments in Excel 2007”

  1. Thanks for the wonderful post.

    A friend asked me about this not long ago, and it would have been easier pointing him to this post instead of explaining it all over the phone 🙂

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.