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. What if you want to print the comments added to individual columns in your printout? Excel provides a way to do this. Read on to know how.
1. Open an Excel sheet. Assume this is what your initial set of data looks like.
Some cells have comments added to them and some don't. You can show, hide, or insert comments to a cell in a sheet.
2. Go to the Page Layout tab and click on the arrow to open the Page Setup menu.
3. This is how the Page Setup menu looks like. Go to the Sheet tab in this menu and select the desired option given under Comments.
4. The Comments menu has three options.
- At the end.
- As displayed in the sheet.
If you select the None option from the comments menu, no comments will be printed when you print the page.
This is how the page will look when it is printed.
6. At the End
If you select the At the end option from the comments menu, the comments will be printed at the end of the data while printing the sheet.
The resulting printed data will look like this. Page one will have your data and page two has the comments in the individual cells printed along with the cell number.
7. As Displayed on Sheet
If you select this option, then 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 will show the comments. Similarly, you may choose to show the comments that you want to be printed along with the data.
Select the As displayed on sheet option from the Page Layout menu. Select Page setup, then go to the Sheet Comments menu.
The results will be printed like this. All the comments will get printed as they appear on the sheet.
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