Easily print comments in Excel

In this article you'll learn how to print comments in Excel 365, 2021, 2019, 2016, and other versions. Read this post if your task is to get cell notes printed at the end of the spreadsheet or if you need to copy them to paper as displayed in your table.

Excel comments work perfectly if you need to add a note to remind somebody about the changes you made. This feature also streamlines work if you want to provide additional information without modifying your worksheet data. If cell notes is a vital part of your Excel documents then printing comments along with other data may be one of your day-to-day tasks. This can make handouts more informative and add helpful information to the daily reports for your boss.

It's possible to print comments at the end of your Excel worksheet or display them all and copy to paper exactly as they appear in your table, next to the cells they relate to.

Print comments at the end of your Excel worksheet

If notes in your Excel table are informative and their contents are clear even isolated from the commented cell, you can easily get them to paper at the end of the page. It's also better to print cell notes below the rest of the data if they overlap important details when displayed. It's doesn't involve any copying and pasting, just follow the steps below:

  1. In Excel go to the Page Layout tab and find the Page Setup section.
    Go to the Page Layout tab and find the Page Setup section
  2. Click on the bottom-right expand arrow icon to get the Page Setup window appear.
    Click on the bottom-right expand arrow icon to get the Page Setup window
  3. On the Page Setup window click on the Sheet tab, then click on the down arrow and select the option At end of sheet from the Comments drop-down list.
    Select the At end of sheet option
  4. Click the Print... button.
    Press the Print... button

You'll see the Print Preview page in Excel. If you scroll down, you'll find the comments with their cell addresses ready for printing.
Use this option for the comments that contain complete information

Use this option for the comments that contain complete information you need to get visible on paper.

If your notes closely relate to the cell information, it may be ineffective to print them at the end of a sheet. In this case you can print comments in Excel 2010-2016 as displayed in your table.

  1. Open your table in Excel, go to the Review tab and click on the Show All Comments option.
    Go to the Review tab and click on the Show All Comments option

    You'll see your cell notes displayed.
    See all cell notes displayed

    Tip. On this step you can also change the way the comments are shown by drag-n-dropping to make sure that important details are visible and not overlapped.

  2. Go to the Page Layout tab and click on the Print Titles icon.
    Click on the Print Titles icon under the Page Layout tab in Excel
  3. You will see the Page Setup window. Click on the small down arrow next to the Comments drop-down list and select the option As displayed on sheet.
    Select the As displayed on sheet option
  4. Press the Print button to preview the page. You will get the comments at a glance.
    Preview the comments before printing

Now you know how to print comments in Excel 2016-2010 as displayed or at the bottom of the table. If you want to become a real comments guru and learn how to make the best of cell commenting, check out the post we published not so long time ago named How to insert comments in Excel, add pictures, show/hide comments.

That's it! My comments have been successfully printed. Now I'm looking forward to your comments and questions. Be happy and excel in Excel!

Table of contents

29 comments

  1. I need to sort a date column. Some dates have a note after them (*) some will have 2 (**) is there a way to get them to sort the dates with notes? I don't mind comments either, but I need them to print at the bottom of the pages. Help?

    Example:

    Date Amount
    3/4*
    3/5**

    can this be done?

  2. This (printing comments inline) does not work with Microsoft 365 Excel.

  3. How can I name a cell so that when I print the comments at the end of the document it doesn't give the cell reference but a name that I have named the cell? Hope you understand what I am saying.

    I have a big document with a lot of comments on it that I would like to print at the end of the document, but I would like them to look like notations look in an essay at the end of the document.

    For example, instead of saying
    Cell: B3 > Cell: One
    Comment: ...

    Cell: E3 > Cell: Two
    Comment: ...

    Cell: B7 > Cell: Three
    Comment: ...
    etc

    1. Definitely what I'm also wanting to know.

  4. Hai,
    Thank u for the post, I Need to know is there any way to extent the arrow line. If yes please let me know.
    My Website: abc.com

  5. Spent 2 hours on chat with Microsoft and never got comments to show. On old computer running Office 2008 for Mac they show but same workbook on new iMac with Microsoft Excel for Mac V 16.16.11 they will not print or show in preview. Any idea what the difference could be. What version are you using to print. Microsoft person even rolled me back to previous version and comments still won't print.

    Thanks for any help you can offer.

    1. The comments need to be within the print area.

  6. Hi,
    I am thinking of getting your ablebits quicktools to facilitate picture insertion into a Comment. In excel it gets tedious. Just curious,,, would it also be able to print those Comment pictures at the end of the sheet. The option available within excel would only do it for text comments and not pictures. Or do you have other tools that would do it.

    thx,
    jose
    610-349-0458

  7. Can I print a comment from a data page in a pivot table report

    1. If you mean that you want to print your pivot table AND the comments from pivot table data source on one and the same piece of paper, then no, unfortunately, you won't be able to do that.

  8. I am trying to do this with a picture but the it is not coming out. Why?

  9. super super super

  10. Good Post but it's only printing the cell note in printed papers. is it possible to save the same in our excel worksheet that's in soft copy...?

  11. was very usefull

  12. It isn't working for my Excel 2010 .xlsx document. Everything is set as instructed, but I can't get comments to print as displayed on the page. Any thoughts?

    1. Make sure the comments are displayed within the defined printing area.

  13. I have inserted an image in my comment. How can I print it?

  14. Thought-provoking analysis - I am thankful for the points . Does anyone know if my assistant could get access to a fillable Form 101192 PG version to use ?

  15. Thank you sooo much for this post. Your are a true blessing. This is what I needed. God bless you.

  16. Hai,
    Thank u for the post, I Need to know is there any way to extent the arrow line. If yes pls let me know

    1. Hello, Fareeth,

      You can only make it longer in teh editing mode. But it doesn't save for teh standard view. To make teh arrow longer when you edit a comment, you need to open it in the editing mode and drag it till the line is the size you need.

  17. Thanks a lot . .

  18. How can I print the comment page "at the end" with the cell name changed from "A1:A3", etc with a name, i.e. "Bobby"?

  19. Thank you so much.

  20. Thank you so much! Had no idea where to find this!

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)