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.

Download Practice Workbook


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.

How 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.

How to Print Comments in Excel Using Page Layout 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.

How to Print Comments in Excel Using Page Layout Tab

  • 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.

How to Print Comments in Excel Using Page Layout Tab

The final output is shown below.

How to Print Comments in Excel Using Page Layout Tab

Read More: How to Print Worksheet with Comments in Excel (5 Easy Ways)


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.

How to Print Comments in Excel Using Page Setup Feature

  • 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.

How to Print Comments in Excel Using Page Setup Feature

  • 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.

How to Print Comments in Excel Using Page Setup Feature

You can see the resultant output below.

How to Print Comments in Excel Using Page Setup Feature


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.

How to Print Comments in Excel Using VBA

  • 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

How to Print Comments in Excel Using VBA

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.

How to Print Comments in Excel Using VBA

  • 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.

How to Print Comments in Excel Using VBA

  • 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.

How to Print Comments in Excel Using VBA

You can find the resultant output below.

How to Print Comments in Excel Using VBA

Read More: How to Export PDF Comments into an Excel Spreadsheet (3 Quick Tricks)


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.

How to Print Comments in Excel Using Page Layout & Review Tabs

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.

How to Print Comments in Excel Using Page Layout & Review Tabs

  • 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.

How to Print Comments in Excel Using Page Layout & Review Tabs

  • 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.

How to Print Comments in Excel Using Page Layout & Review Tabs

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

How to Print Comments in Excel Using Page Layout & Review Tabs

Read More: Convert Comments to Notes in Excel (3 Suitable Ways)


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!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo