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 » Excel
Excel
Resolved · Urgent Priority · Version 2007
Thu 29 May 2008, 12:58Delegate Benjamin said...
Benjamin has attended:
Project Intro Intermediate course
Excel
How can I make comments visible on a printed spreadsheet?
Thanks
Thu 29 May 2008, 14:40Trainer Amanda said...
RE: Excel
Hi Benjamin
Thank you for your question; and welcome to the forum.
You can print a spreadsheet with comment by doing one of the following:
1. Go to Tools - Options - View. Under the Comments area, select Comment and Indicator and click OK. The comments will now be visible on the spreadsheet. Then go to File - Page Setup - Sheet. Under the section headed Print, choose the As displayed on sheet option by Comments, click OK, then Print.
2. Go to File - Page Setup - Sheet. Under the section headed Print, choose the At end of sheet option by Comments, click OK, then Print.
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. |
Excel tip:View a unique listYou have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column. |
