How to Print Comments Attached to a Cell in Microsoft Excel

Author:
Petite Hubpages Fanatic
Updated date:
Jan 13, 2021

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.

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.

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.

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.

Scroll to Continue

the-5-habits-of-highly-effective-designers

the-best-standing-desks-to-buy-top-3-picks-for-your-home-office

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.

This Is How Each Print-Out Will Look Like Depending on Which Option You Select

This is how the page will look when it is printed if you select none.

If you select at the end, the resulting printed data will look like this. Page one will have your data and page two will have the comments in the individual cells printed along with the cell number.

If you choose the are displayed on the sheet option, the results will be printed like this. All the comments will get printed as they appear on the sheet.

This is how the page will look when it is printed if you select none.

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.