How to Print Comments in Excel 2010

While Microsoft Excel 2010 spreadsheets, in their default format, contain many ways for you to alter the appearance of your worksheets, the only way to add new information is by typing directly into the cells. When you are creating a simple spreadsheet by yourself, this is probably fine. But if you are generating a complex spreadsheet and/or working with others, then you might need another way to enter information on the sheet without including it in a cell on the spreadsheet. You can accomplish this through the use of comments that can be added from the Review tab in Excel. But if you want to learn how to print comments in Excel 2010 that you have added to a spreadsheet, you will need to make some additional adjustments to your spreadsheet.

 

How Do You Print Comments in Excel 2010

 

Attempting to print comments in Excel 2010 can be a frustrating endeavor if you search for the option to do so on the Print menu or the Review tab. Your frustration will not be overcome, however, if you restrict your search to these locations, because the solution to your question of printing comments in Excel 2010 is located in another place. The ability to print comments in Excel 2010 is actually configured from the Page Layout tab, and you have a couple of different options for how you want these comments to be printed.

 

Step 1: Open the spreadsheet for which you want to print comments in Excel 2010.

Step 2: Click the Review tab at the top of the window, then click the Show All Comments button in the Comments section.

show comments in excel 2010

 

Step 3: Click the Page Layout tab at the top of the window.

page layout tab excel 2010

 

Step 4: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon at the top of the window.

excel 2010 page setup menu

 

Step 5: Click the Sheet tab at the top of the window.

Step 6: Click the drop-down menu to the right of Comments, then click the As displayed on sheet option, or click At end of sheet. If you choose the “As displayed on sheet option,” your comments will print as they are currently shown on your spreadsheet. If you choose to print them at the end of the sheet, they will print on a separate sheet at the end of the document.

how to print comments in excel 2010

 

Step 7: Click the Print Preview button at the bottom of the window to see how your printed document will look now that you have chosen to print comments in Excel 2010, then click the Print button at the top of the window to print your spreadsheet with comments.