How to Print Comments in Excel (4 Suitable Ways)

Looking for ways to know how to print comments in Excel? Then, this is the right place for you. Usually, when we print an excel sheet it only prints the dataset. To print the comments added in the excel sheet we must go through some extra steps. Here, you will find 4 different step-by-step explained ways to print comments in Excel.

Table of Contents hide

Download Practice Workbook

4 Ways to Print Comments in Excel

1. Using Page Layout Tab to Print Comments at End of Sheet

2. Using Page Setup Feature to Print Comments in Excel

3. Excel VBA to Print Comments in Excel

4. Use of Page Layout & Review Tabs to Print Comments/Notes as Displayed

Conclusion

Download Practice Workbook

Printing Comments in Excel.xlsm

4 Ways to Print Comments in Excel

Here, we have the following dataset of an Institution containing the data of Name, Designation, Salary and Working Days. We will use this dataset to describe the step-by-step ways to print comments in Excel.

1. Using Page Layout Tab to Print Comments at End of Sheet

For the first method, we will use Page Layout Tab to print comments at the end of the sheet. The Page Layout Tab has all of the options for arranging your document pages exactly how you want them. You can do it by following the few steps.

Steps:

In the beginning, open the Page Layout tab.
Then, click the Page Setup button at the corner of the tab.

After this, the Page Setup dialog box will appear.
Then, select Sheet and set Comments and notes as At end of sheet.

Finally, Press Print.

The Print tab will appear.
From there click on the Print box.

Then, Save your print output in your desired location and name. Here, we will save our file as a PDF Document named as how to print comments.

The final output is shown below.

2. Using Page Setup Feature to Print Comments in Excel

We can also print comments in excel by using the Page Setup Option. The following steps will guide you to print comments in excel using Page Setup.

Steps:

First, click on the File tab.

Then go to the Print bar and click on Page Setup.

Now, the Page Setup box will appear.
Then, go to Sheet and select At end of sheet as Comments and notes.
Finally, press OK.

This will open the Print Bar.
From there click on the Print box.

Then, Save your print output in your desired location and name. Here, we will save our file as a PDF Document named how to print comments 2.

You can see the resultant output below.

Similar Readings

3. Excel VBA to Print Comments in Excel

We can use VBA to print comments in Excel. VBA is a programming language. When you run the macros, you can see the result in the resultant cell. You can follow the following steps to use VBA to print comments in your Excel workbook.

Steps:

First, open the Developer tab >> click on Visual Basic.

Alternatively, you can also use the keyboard shortcut ALT+F11 to do this.

Then, go to Insert >> select Module.

After that, write the following code in your Module.

Option Explicit
Sub print_comments()
Application.DisplayCommentIndicator = xlCommentAndIndicator
ActiveSheet.PrintPreview
ActiveSheet.PageSetup.PrintComments = xlPrintSheetEnd
End Sub

Code Breakdown

First, we created Sub Procedure as print_comments().
Then, we displayed the comment indicator as Comment and Indicator.
Next, we activated Print Preview.
Finally, activated Page Setup as SheetEnd to print comments.

Then, go to the Developer tab >> click on Macros.

This will open the Macro dialogue box.
Inside the box choose your Macro. In our case, we chose the Print comments code.
Then, press Run.

This will open the Print Preview version.
Then, click on Print.

Now, the Print box will appear.
After that, click on OK.

Then, Save your print output in your desired location and name. Here, we will save our file as a PDF Document named as how to print comments 3.

You can find the resultant output below.

4. Use of Page Layout & Review Tabs to Print Comments/Notes as Displayed

Using the Page Layout & Review tab you can only print Notes as displayed in the Excel workbook. Notes are quite similar to comments except they are shown right beside the cell in a box.

As I’m using the Microsoft 365 version it will only Print notes but the earlier version prints comments.

We have added two notes to show you how to print notes as displayed in the Excel workbook.

You can print Notes as displayed in your excel workbook by following the steps below.

Steps:

First, open the Review tab >> click on Notes >> select Show All Notes.

Then, go to Page Layout >> click on Print Titles.

This will open the Page Setup box.
From there, select As displayed on sheet (notes only) as Comments and notes.

After that, click on the Print.

This will open the Print Bar.
Then, click on Print box.

After that, Save your print output in your desired location and name. Here, we will save our file as a PDF Document named as how to print comments 4.

You can see the print version of the Excel workbook below.

Conclusion

So, in this article, you will find 4 ways how to Print Comments in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!