When you print an Excel worksheet, you can also print all the comments that have been added to the sheet.
You can print the Excel comments the way they appear as pop-ups on the worksheet, or print all the comments at the end of the worksheet.
If you’re using an older version of Excel, there are details here — Printing Comments in Excel 2003.
Print the Comments as Displayed
When printing Excel comments as displayed, you can either show all the comments, or just show one or more comments that you want to print.
To show all the comments, on the Ribbon’s Review tab, click Show All Comments.
Show Specific Comment
To show a specific comment, select a cell that contains a comment. Then, on the Ribbon’s Review tab, click Show/Hide Comment.
Arrange Comments for Printing
If necessary, rearrange the comments, so they don’t overlap, or cover the data.
Page Setup Dialog Box
Then, on the Ribbon’s Page Layout tab, click the More button for Sheet Options
In the Page Setup dialog box, on the Sheet tab, select As Displayed on Sheet from the Comments drop down.
Quick Check With Print Preview
If you want to see how the comments will look when printed, click Print Preview
Click OK to close the Page Setup dialog box.
Print Comments at the End
Instead of printing the Excel comments as displayed, you can print them at the end of the worksheet.
On the Ribbon’s Page Layout tab, click the More button for Sheet Options
In the Page Setup dialog box, on the Sheet tab, select As Displayed on Sheet from the Comments drop down.
If you want to see how the comments will look when printed, click Print Preview. The comments and their addresses will appear on a separate sheet, at the end of the worksheet’s data.
Click OK to close the Page Setup dialog box.
Watch the Video
This Excel Quick Tips video shows how to display all the worksheet comments, and then print the worksheet with the comments displayed.
____________
Thanks. It was very useful
Saved me a bunch of grief! Thanks!
Exactly the same which i was looking for….
Thanks