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.
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.
Each comment is listed separately along with the location of the comment within the worksheet.
The comments are printed exactly how they appear on the worksheet. Here, all comments have been displayed for printing.
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.