View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


muzzab Wrote:
excel cell comments dont print although visible in print preview


Hi muzzab

Try this

Print a worksheet with comments
If you want to print the comments in the positions where they appear on
the sheet, you must first display the comments that you want to print.
To display all comments, click Comments on the View menu. Move and
resize the comments, as necessary.

To display an individual comment, right-click the cell that contains
the comment, and then click Show Comment on the shortcut menu.

Click the worksheet.


On the File menu, click Page Setup, and then click the Sheet tab.


Do one of the following:
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 appear on the worksheet, click As
displayed on sheet in the Comments box.

Note To print comments, you must also print the worksheet that
contains them.


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=474670