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.
CommentsShowAll
To show a specific comment, select a cell that contains a comment. Then, on the Ribbon’s Review tab, click Show/Hide Comment.
CommentsShowHide
If necessary, rearrange the comments, so they don’t overlap, or cover the data.
CommentsArrange
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.
CommentsPageSetup
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.

____________