Updated date:

How to Print Comments Attached to a Cell in Microsoft Excel

Neha is a software professional with 13+ years of experience in the IT Industry. She enjoys writing technical tutorials.

Comments can be attached to cells in an Excel sheet. When you normally print a worksheet, it just prints the data that is present. But what if you want to print the comments added to individual columns in your printout? Excel provides a way to do this, and I'm going to show you below.

comments on an Excel spreadsheet

comments on an Excel spreadsheet

Steps

1. Open an Excel sheet. Assume this is what your initial set of data looks like.

2. As you can see below, some cells have comments added to them. You can show, hide, or insert comments to a cell in a sheet.

comments on an Excel spreadsheet

comments on an Excel spreadsheet

tutorial-ms-excel-how-to-print-comments-attached-to-a-cell

3. Go to the Page Layout tab and click on the arrow to open the Page Setup menu.

3. Go to the Page Layout tab and click on the arrow to open the Page Setup menu.

3. Go to the Page Layout tab and click on the arrow to open the Page Setup menu.

4. The below picture shows how the Page Setup menu is set up. Go to the Sheet tab in this menu and select the desired option given under Comments.

This is how the Page Setup menu is set up

This is how the Page Setup menu is set up

4. The Comments menu has three options (see photos below).

  • None: No comments will be printed when you print the page.
  • At the end: If you select this option, the comments will be printed at the end of the data.
  • As displayed in the sheet: If you select this option, only comments shown on the sheet will be printed. To show a particular comment, right-click on the cell with comments and select the show/hide comments option.
tutorial-ms-excel-how-to-print-comments-attached-to-a-cell
tutorial-ms-excel-how-to-print-comments-attached-to-a-cell
tutorial-ms-excel-how-to-print-comments-attached-to-a-cell
tutorial-ms-excel-how-to-print-comments-attached-to-a-cell
tutorial-ms-excel-how-to-print-comments-attached-to-a-cell

This article is accurate and true to the best of the author’s knowledge. Content is for informational or entertainment purposes only and does not substitute for personal counsel or professional advice in business, financial, legal, or technical matters.

© 2013 Petite Hubpages Fanatic

Related Articles