How to Print Comments in Excel Worksheet

This post will guide you how to print comments in your Excel Worksheet. How do I print comments while print your worksheet.

Print Comments


When you print a worksheet, the comments are not printed by default. As the setting of comments printing is disabled. If you want to print your comments while print your worksheet, you just do the following steps:

#1 Select the worksheet that contains the comments that you want to print.

#2 go to REVIEW tab, click Show All Comments command under Comments group. All comments would be displayed in your current worksheet.

print comments1

print comments2

#3 go to PAGE LAYOUT tab, click the flyout on the right to launch the Page Setup dialog under Page Setup group.

print comments3

#4 select the Sheet tab in the Page Setup dialog, and choose either At end of sheet or As displayed on sheet in the Comments list box.

print comments4

#5 click print or Print Preview to see a preview of the comments.

Note: when you choose At the end of sheet setting, all the comments would be printed at the end of the worksheet as shown.

print comments5

When you choose As displayed on sheet, all the comments would be printed in the worksheet as shown.

print comments6

 

 

Leave a Reply