Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

printing comments from Excel

Posted by Franco on July 12, 2001 1:29 PM

I have a database where one cell contains a project name with comments. I would like to be able to print a particular comment from Excel. I have tried to "unhide" the comment and placing it on top of the page being printed, but that doesn't work. Do you know how to get around this problem.
Thanks,
Franco

Re: printing comments from Excel

Posted by Mark W. on July 12, 2001 1:35 PM

Use the Edit | Page Setup... menu command to go to
the "Sheet" tab on the Page Setup dialog box. Set
the "Comments" field to "As displayed on sheet".
Next, use the Tools | Options... menu command to
access the "View" tab. Make sure that the
"Comment and Indicator" radio button is depressed.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.