Saturday, June 11, 2011

How to Print Comments in Excel


1. Start Microsoft Excel and open a spreadsheet that contains comments that you would like to print along with your spreadsheet.
2. Choose the 'File' menu and click 'Page Setup' to bring up the 'Page Setup' dialog box. Within the 'Page Setup' dialog box, you can make different changes that will affect the pages of your spreadsheet.
3. Click on the 'Sheet' tab at the top of the 'Page Setup' dialog box to show the sheet page setup options.
4. Locate the 'Print' section of the 'Sheet' options, in the center of the 'Page Setup' dialog box.
5. Select either 'At end of sheet' or 'As displayed on sheet' options from the 'Comments' drop-down menu. The 'At end of sheet' option will print the comments from the spreadsheet at the end of each sheet, and the 'As displayed on sheet' option will print the comments just as they appear on the spreadsheet while it's open on your screen.
6. Press the 'OK' button with your mouse to close the 'Page Setup' dialog box and set Excel to print comments that appear on your spreadsheets.
7. Print the spreadsheet by choosing the 'File' menu, clicking on 'Print' and then printing from the 'Print' dialog box.

Blogger news