Print Comments in Excel

Publication Date :

Blog Author :

Download FREE Print Comments Excel Template and Follow Along!
Print Comments Excel Template.xlsx

Table Of Contents

arrow

How to Print Comments in Excel?

To print comments in Excel, we need to go to the "Print" section from the "Files" tab and "Page Setup" tab, where we may find any options to print comments and where we want to display them, whether on the end of the sheet or as they are present in the sheet.

Methods to Print Comments

There are two ways to print our handy comments in Excel and the report.

  1. Using an Excel "Page Layout" option.
  2. Using print preview method in Excel.

Again, there are a couple of options to print the comments. We can print the comment at the end of the page or as displayed on the worksheet.

#1 Print Comments using Excel Page Layout Option

Assume you have the report below in your Excel sheet and want to print the comments using the page layout option.

If there are a lot of comments, it is better to print all the comments at the end of the sheet. Printing all the comments in Excel after the rest of the data will eliminate overlapping of the crucial cell comments when the details are displayed.

We need to do some settings tuning to get this done.

Print the comments at the end of the Excel sheet

Below are the steps for printing comments at the end of the Excel sheet:

  1. Your data should be like this.


    print comments in excel step 1

    If you look at the cells from E2 to E8, it contains some comments in it. A little red mark indicates that the cells have comments in them.

    For printing the comments at the end of the excel sheet, comments should appear by default. Otherwise, it will print the comments as shown in the sheet.

  2. Now, go to "Page Layout," then "Page Setup," and click on the little arrow mark.


    print comments in excel step 2

  3. Click on the bottom right expand arrow to open the dialog box below.


    print comments in excel step 3

  4. Now, go to the "Sheet" tab and click on it.


    print comments in excel step 4

  5. After clicking on the "Sheet" tab, select the "At the end of the sheet" option under the "Comments" section.


    print comments in excel step 5

  6. Once the "At the end of sheet" option is selected, click on the "Print" option.


    page setup

  7. Once the "Print" option is selected, it will take you to the "Print Preview" section.


    print preview

    It will print the report on the first page. Then, on the second page, it will print all the comments. And the final output will be as per the below image.

    print comments in excel step 9
    print comments in excel step 10

Print the Comments as Shown in the Active Window

In the last example, we have seen printing all the cell comments at the end of the sheet. Instead, we can print the comments referring or pointing to the cell itself. For this, we need to select the other option in step 5.

page set up

After this, click on the "Print" option to open the "Print Preview" dialog box. Next, click on the "Print" option to get the print, and the print will be as shown in the below image.

print comments in excel step 11

#2 Using Print Preview Method

In the last example, we have printed the comments using a "Page Layout" option. We can also print the comments using the "Print" option. It is very similar to the last method but instead of going for "Page Layout," select the "Print option" (Ctrl + P).

  • Step 1: Go to "File" and select the "Print" option.
go to file select print
  • Step 2: Once you click on the "Print" option, it will open the below window and click on Page Setup.
print
  • Step 3: This will open the page, set up a dialog box, and select the "Sheet" tab.
page setup - sheet tab
  • Step 4: After clicking on the "Sheet" tab, choose the "At the end of sheet" option under the "Comments" section.
page setup
  • The "At the end of sheet" option will print the comments at the end of the sheet.
  • The "As displayed on sheet" option can print as shown in the Excel sheet.
  • The option "None" will print anything.