Print Comments in Excel

Add to Favorites

How to print the comments in a worksheet when you print from Excel.

This includes how to print the comments within the worksheet and how to print them at the end of the worksheet all in one place.

Steps to Print Comments

  1. Go to the Page Layout tab and click the little button in the bottom right corner of the Page Setup section.
  2. In the window that opens, go to the Sheet tab and look for the Comments drop down menu on the right.  From that menu, select either At end of sheet, if you want your comments to be printed separate from the spreadsheet and at the very end, or As displayed on sheet if you want them to be printed on the actual worksheet.
  3. Once you've made your selection, hit OK.  If you chose the option At end of sheet, you are done.  If you chose the option As displayed on sheet, look to step 4.
  4. The option As displayed on sheet does exactly what it sounds like; it prints comments exactly how you see them in the spreadsheet.  This means that you need to make a comment, or all of them, visible before you go to print.

    To make individual comments visible, select the cell that contains them and go to the Review tab and click Show/Hide Comment.  You can do this with as many comments as you like.  Alternatively, you can go to the Review tab and click the button Show All Comments to display every comment in the worksheet.

    However many comments you show, this is how many will be included when you go to print the worksheet.

At end of sheet Example:

Each comment is listed separately along with the location of the comment within the worksheet.

As displayed on sheet Example:

The comments are printed exactly how they appear on the worksheet.  Here, all comments have been displayed for printing.

Notes

This is very helpful when you are evaluating a spreadsheet or looking over a project that has important notes throughout it.  However, you should be careful not to print comments "as displayed" in the worksheet or you risk increasing clutter and confusion; this is only a good option when your comments are unobtrusive.

Make sure to download the accompanying spreadsheet so you can see this in action.


Downloadable Files: Excel File

Similar Content on TeachExcel
Get Comment Text from Cell Comments in Excel - UDF
Macro: This free Excel UDF outputs all text from a comment in Excel. This benefit of this UDF is ...
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Macro: Delete a comment in Excel with this macro. You can permanently remove or delete a specific...
Hide Comments in Excel Completely - Even Indicators Will not Appear
Macro: Hide all comments in an Excel workbook. No indicators will be displayed and comments will ...
Hide Specific Comments in Excel - Comments Will Still Display on Hover
Macro: Hide specific comments in Excel with this macro. Comments are still visible on hoveri...
Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
Macro: Hide comments in Excel with this macro. Comment indicators will still appear in the ce...
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
Macro: This macro in Excel allows you to display or show a particular comment in Excel. This will...