Excel 2007: How to Print Comments

Posted August 8, 2008 by Rob Rogers in Microsoft Excel

It can be quite helpful to have a printout of all the comments that have been inserted on a worksheet. This way you have a hard copy to use as you make any necessary changes to the worksheet.


1. Open the desired worksheet.

2. Go to the Ribbon and select the Page Layout tab.

3. Go the bottom-right corner of the Page Layout section and click the small icon.

4. When the Page Setup dialog box appears, select the Sheet tab.

5. Use the Comments dropdown to select how you want the comments printed. Options are None, At end of sheet, and As displayed on sheet.

6. Click the OK button.

Now when you print the spreadsheet, the comments will be included.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • Anonymous

    This didnt work for me… please help…

    • Anonymous

      This did not work for me either….sorry….still need help too!!

  • SW

    Didn’t work for me either. Only works for displaying the comments as they are shown on the sheet, not for the list at the bottom.

  • JL

    It works as displayed on the sheet if you go first to the REVIEW tab and click on SHOW COMMENTS and then go to PAGE LAYOUT –> PAGE SET UP –> SHEET –> COMMENTS –> AS DISPLAYED. Try this and it should work.

    • Kamro2006

      Thanks JL. It works.

      Ronald

  • Erkinous

    thanks very much!!!

  • Klj

    and make sure your page margins/print area includes the comments

  • vivek

    Thanks .. really helpful !!!

  • Katia

    Thanks, it works!!!

  • Molly

    Worked and thanks!!!!!!!