Excel: print comments - how it works
Occasionally, it can be very useful to print the comments on an Excel worksheet. We will briefly show you the corresponding steps below. The information provided relates to Microsoft Office 2010, but works similarly in the other versions of Excel.
Print Excel worksheet with your comments
To be able to print your comments in Excel, you must first make them permanently visible.
- If you only want to print isolated comments, right-click on the relevant cell and select the "Show / hide comments" option in the context menu. The comment is now permanently displayed on your worksheet.
- If you have annotated several cells that you would like to have all of them on your printout, you do not have to manually bring them all to the front of your worksheet.
- If so, click the Review tab and then go to the Comments group on the Quick Launch. There you choose the option "Show all comments".
- Now click on "File" in the upper left corner and select "Page Setup" under "Print". If you switch to the "Sheet" category above, you can select the appropriate option for the "Comments" here. Decide on "As shown on the sheet" and print out the document.