How to Print Comments in Excel

Techwalla may earn compensation through affiliate links in this story.
Printing Excel comments gives you the full picture.
Image Credit: Microsoft

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.


Step 1

Hover over any cell that has a colored dogear, to display a comment.
Image Credit: Microsoft

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.


Video of the Day

Step 2

Click Show All Comments from the Review tab to automatically display comments.
Image Credit: Microsoft

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.


Step 3

Display comments in Page Layout Setup options.
Image Credit: Microsoft

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.


Step 4

Choose where to print comments: either as displayed or at the end of the sheet.
Image Credit: Microsoft

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.


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.


references & resources