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.

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

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

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

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

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

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

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

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.

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.

____________