Neha is a software professional who specializes in ServiceNow Customization and Implementation. She likes writing tutorial articles.
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.
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.
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.
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 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