98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Comment Boxes
2002 excel microsoft training - Comment Boxes
Resolved · Low Priority · Version Standard
Wed 3 Jan 2007, 17:14Delegate Laura said...
Laura has attended:
Excel Intermediate course
Comment Boxes
I used the comments boxes today on a report and moved them to appear outside the report detail, but when i printed out the report the comments do not show up even though they were in the print area. I was wondering if it is possible to print them and if so how to instruct it to do so or if you can only view the comments on the screen?
Many thanks
Laura
Thu 4 Jan 2007, 11:43Trainer Amanda said...
RE: Comment Boxes
Hi Laura
Thanks for your question.
There are a couple of options for printing comments.
Your first option is to show the comments in the spreadsheet - you can do this by going to Tools-Options-View then selecting the Comments and Indicator option under Comments and click OK. Then go to File-Page Setup-Sheet and there is a dropdown arrow next to Comments: where you can select As displayed on sheet then print.
Your second option is to get the comments to print underneath your spreadsheet. To do this go to File-Page Setup-Sheet then use the dropdown arrow next to Comments: to select At the end of sheet.
I hope this helps.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
