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.

____________

You may also like...

9 Responses

  1. exceltipsmonster says:

    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 :)

  2. Justin says:

    Thanks a lot !
    Very usefull tutorial.
    Cheers mate :)

  3. Nick says:

    fantastic!! this is what I was after!! thanks

  4. Wendy says:

    thanks for this usefull tutorial. It’s really help.

  5. Paul says:

    Just what I needed many thanks!!

  6. Nitin Gupta says:

    thanx

  7. Aftab says:

    Thanks. It was very useful

  8. RMELE says:

    Saved me a bunch of grief! Thanks!

  9. Jitendra Singh says:

    Exactly the same which i was looking for….

    Thanks

Leave a Reply to Nick Cancel reply

Your email address will not be published. Required fields are marked *