If you've added comments to an Excel worksheet, you have a couple of built-in options for printing the comments.

Show the comments on the worksheet, and print them as displayed. Print the list of comments at the end of the worksheet, on a separate printed page.

Printing the comments on the worksheet is okay if there are only a couple of comments, and you can arrange them so they don't cover the data.

For more than a couple of comments, the list at the end of the worksheet is a better choice. However, with the built-in list printing option, you just get the cell address and comment, printed in a long, single column.

Create Your Own List of Comments

Instead of using the built-in list of printed comments, you can use a macro to create your own list of comments on a separate worksheet, and print that list.

Continue reading Print a Customized List of Excel Comments