MrExcel Publishing
Your One Stop for Excel Tips & Solutions

printing comments


Posted by archana on January 23, 2002 10:45 PM

How can i print a worksheet alongwith the comments that have been inserted in the worksheet. Such that i have both my data as well as comments on the printout on the same sheet.


Posted by anno on January 23, 2002 11:06 PM

archana
The following is a straight lift from the excel help topic "print comments"

Print comments

1 Click the worksheet.
2 On the File menu, click Page Setup, and then click the Sheet tab.
3 To print the comments at the end of the sheet, click At end of sheet in the Comments box.

To print the comments where they are displayed on the worksheet, click As displayed on sheet in the Comments box.

Note If you click As displayed on sheet, Microsoft Excel prints only the comments that are displayed. To display all comments, click Comments on the View menu. To display an individual comment, right-click the cell that contains the comment, and then click Show Comment on the shortcut menu.