How to Print Comments in Excel
Comments in Excel 2013 can help annotate parts of a spreadsheet where comments wouldn't fit, such as within a table. Even though comments don't directly display on the spreadsheet, you can print them on paper with your content. It is possible to print a comment in its original location or as a group at the end of the spreadsheet.
Hover over any cell marked by a color in the upper right corner. This dogeared cell has a comment attached to it; displaying it reveals a box with an arrow pointing toward the cell. Inside the box is a comment and the name of the user who typed it.
Click the "Review" tab in the upper toolbar. Selecting "Show All Comments" reveals any comments on the worksheet, even when you don't hover the mouse over the cell. At this point, however, printing the document still won't show the comments.
Switch to the "Page Layout" tab and click the arrow in the lower right corner of Page Setup to open a box with more advanced options, including "Comments" in the Print category. By default, this is set to "None," meaning comments don't print even when shown onscreen.
Select "As displayed on sheet" to print the document as you see it on the paper. Alternatively, choose "At end of sheet" to display comments in a plain text list following your spreadsheet's content. Click "OK" to save your changes or "Print" to begin printing.
Tips & Warnings
- Unlike printing comments in plain text at the end of a sheet, printing comments as displayed includes the box and arrow.
- Changing the print order to "Over, then down" prints in a Z-formation and can make sorting easier after printing; using this method, comments displayed beside content print immediately afterward. Otherwise, content prints in an N-formation, separating comments from their related content.
- Reducing margin space can help fit small comments that might otherwise print on another page.
- Be mindful of comment placement; if your comments display a distance from their related content, you might print more pages than necessary.