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.