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