Excel 2007: How to Print Comments
Contributed by Rob Rogers 
Tagged: 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.
You may also like -
How To Email an Excel WorkbookExcel 2007: Move Page Breaks
Excel 2007: Have Your Data Read Back To You
Excel 2003: How To Disable Automatic Recalculation in a Worksheet
Excel 2007: Set the Default Column Width for a Worksheet
Excel 2007: Locate Cells Containing Conditional Formatting
Excel 2007: How to View Twitter Updates (Tweets) in a Worksheet
Classic ASP: Generate Excel spreadsheets on the fly
Anonymous said on August 31, 2009
This didnt work for me… please help…
Anonymous said on January 7, 2010
This did not work for me either….sorry….still need help too!!
SW said on March 3, 2010
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 said on June 2, 2010
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 said on September 13, 2010
Thanks JL. It works.
Ronald
Erkinous said on January 9, 2011
thanks very much!!!
Klj said on February 3, 2011
and make sure your page margins/print area includes the comments
vivek said on March 15, 2011
Thanks .. really helpful !!!
Katia said on August 25, 2011
Thanks, it works!!!