How to Print Comments and Notes in Excel while Printing a Sheet

puneet-gogia-excel-champs

- Written by Puneet

Excel allows you to add comments and notes in a sheet to specify your comments or additional information. When you print your data, Excel lets you print those comments and notes along with the primary data.

In this tutorial, we are going to learn to do this. So, let’s get started.

Note: Comments and Notes are two different things, but both serve nearly the same purpose.

There are two major options to print notes and one to print comments while printing a sheet.

Print Notes and Comments at the End (Last Page)

This is the most helpful way to print comments and notes. In the example below, you have one comment and one note; now, you must print them at the end of the print (last page).

print-notes-and-commands
  1. First, go to the Page Layout tab and then click on the “Print Title” option to open the print title dialog box.
    2-print-title-option
  2. After that, click on the Comments and Notes drop-down to open it.
    3-comments-and-notes-drop-down
  3. Select “At end of the sheet” from that drop down. It tells Excel to print all the comments and the notes at the end of the print (last page).
    4-choose-at-the-end-of-sheet
  4. In the end, click OK to save the settings.

Now, when you open the print preview option, you can see that there’s an extra page with comments and notes at the end.

extra-page-with-comments-and-notes

As I said, this option is the best as it prints comments and notes to a separate page for the user to refer to without interrupting the main data.

Note: When you apply this setting, it applies to all the sheets you have in the workbook.

Print Notes Directly on the Main Sheet

This option is good for using fewer notes on a sheet. You can print them directly with the data on the sheet.

print-notes-on-main-sheet

For this, you need to change two settings:

  1. Go to the Page Layout and click on the Print Titles.
    7-page-layout-tab
  2. After that, select the “As Displayed on Sheets (notes only). Click OK.
    8-choose-as-displayed-on-sheets
  3. Go to the review tab and click the “Notes” drop-down.
    9-click-notes-drop-down
  4. From the drop down, select “Show All Notes”.  
    10-select-show-all-notes

When you open the print preview, this will show you all the notes straight on the sheet while printing.

Last Updated: October 30, 2023