Select At end of sheet – if you want to print comments at the end of the worksheet.Select None – If you don’t want to print any comments.These are the same options as discussed above: Select the sheet tab and you’ll find the Print comments options in the drop-down. In the Print Preview screen, at the bottom of the screen, there is a Page Setup option.Go to File –> Print (or use the keyboard shortcut: Ctrl + P).There is another way to access the Page Setup dialogue box options. Print Comments in Excel using the Print Preview It will print the comments and you’ll get exactly what you see on your screen. In the Page Setup dialogue box, within the Sheet tab, go to the Comments drop-down and select As displayed on sheet.If a comment is visible, it hides it, and if it is hidden, then this makes it visible. If you want to show some of the comments (and not all), select the cell which has the comment, go to Review tab –> Comments –> Show/Hide Comment.
This would instantly make all the comments show up close to the cell that holds that comment. To do this, go to Review Tab –> Comments –> Show All Comments.
#EXCEL 2016 SHOW COMMENTS WHEN PRINTING HOW TO#
Here is a tutorial that will show you how to quickly get a list of all the comments in a worksheet. Using this method, you can get a list of all the comments, when printed, but you can’t get a list of the comments in the workbook itself. This could be especially helpful if your worksheet gets reviewed by multiple people and you have different commenters. The benefit of using this method is that it gives you all the comments in one place along with the cell address and the commenter’s name. Now when you print the worksheet, all the comments would be printed at the end of the worksheet. (You can also click on Print Preview to see how it would look when printed). In the Page Setup dialogue box, within the Sheet tab, go to the Comments drop-down and select At end of sheet.In the Sheet Options group, click on the small arrow icon at the bottom right of the group (called the dialogue box launcher).Print Comments as Displayed on the Sheet.Print Comments at the End of the Sheet.There are two ways you can print comments in Excel: You need to make a few changes in the settings to get this done. If you have a lot of comments in a worksheet and you print it, by default the comments would not get printed. Print Comments in Excel using the Page Setup from Ribbon Print Comments in Excel using the Print Preview.Print Comments as Displayed in the Worksheet.Print Comments in Excel using the Page Setup from Ribbon."Comments and indicators" - Both Comments and indicators will be displayed.If you select this options, red triangle indicators will be shown on Cells which has Comments and Comments will be displayed once mouse pointer is kept over the Cell, which has a Comment. "Indictors only, and comments on hover" - This is the default option.
If you select this option, Comment indicator red triangles will be hidden. "No comments or indicators" - If you select "No comments or indicators" radio button, no comments or red triangle indicators will be shown on Cells which has comments until you click Excel Ribbon > Review Tab, Comments Group and click "Show all Comments" button or Excel Ribbon > Review Tab, Comments Group and click "Show/Hide Comment" button.You can see that there are three options related with display of Comments in Excel worksheet, as shown in below image. Open "Advanced" Panel by clicking on it in left-side menu. Open Excel Options dialog box window from Excel Backstage View. If you want to hide or show comment indicator red triangles from Excel worksheet Cells, you can do it from Excel Options dialog box window, as explained below.