How to Print Comments in Excel (4 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Print Comments in Excel: 4 Suitable Ways

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 the 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 a 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


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

Read More: How to Adjust Print Settings in Excel


3. Excel VBA to Print Comments in Excel

We can use VBA to print comments in Excel. 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 VBARead More: How to Not Print Empty Cells in Excel


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: How to Print Landscape in Excel


Download Practice Workbook


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo