|  

» Printing Cell Comments in Excel 2007

CATEGORY - Excel Editing VERSION - Microsoft Excel 2007
To print the Comments within the print area:

1. Select Page Layout - click the dialog box Launcher arrow symbol at the right corner of Page Setup Group.
2. In Page Setup dialog box select the Sheet tab.
3. Select one of the following options from the Comments dropdown list:
None: No Comments are printed.
At end of sheet: Comments are printed on a separate page after printing the sheet.
As displayed on sheet: Only displayed Comments are printed.

To print a single Comment in cell:
1. Select Page Layout - click the dialog box Launcher arrow symbol at the right corner of Page Setup Group.
2. In Page Setup dialog box select the Sheet tab.
3. In the Print area text box, insert the cell address.
4. From the Comments dropdown list, select At end of sheet.
5. Click the Print button at the bottom of the Page Setup dialog box.

Rate This Tip
12 34 5
Rating: 4.18     Views: 12101
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments