by Allen Wyatt
(last updated October 10, 2015)
Hannah already knows how to print comments in Excel but she can't find any information about printing formatted comments. She has formatted the comments to be bold, to have colors, etc., but those formats don't show when printing.
Excel provides a way to make sure that the comments print out in a formatted manner, but that way isn't immediately obvious. Follow these steps:
Figure 1. The Sheet tab of the Page Setup dialog box.
It should be noted that Excel only prints those comments that are visible on the sheet when the printing occurs. The best thing to do is to make sure that you make your comments visible before actually printing.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (1029) applies to Microsoft Excel 2007, 2010, and 2013.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Excel makes it easy to filter a data table based on various values in that table. It isn't so easy to filter according to ...Discover More
Want your comment boxes to appear someplace other than the right side of a cell? You may be out of luck, and here's why.Discover More
When you protect a worksheet, Excel stops users from editing or otherwise making changes to the data in the worksheet. If ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.