Excel

The UK's most regular instructor-led training courses.
Training information: excel training course · Excel-courses-london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Urgent Priority · Version 2007

Excel

Benjamin has attended:
Project Intro Intermediate course

by - delegate Benjamin [2 posts] (2008 May 29 Thu, 12:58) Reply

How can I make comments visible on a printed spreadsheet?
Thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel

by - trainer Amanda diamond contributer [1208 posts] (2008 May 29 Thu, 14:40) Reply

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

· What's Better Than the Help Function in Excel? Microsoft Training
· Benefits of learning about Excel charts
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Microsoft Excel Training - Numerical excellence for all
· Interesting Lifestyle Applications for Microsoft Excel

Please browse our web site to find out more about
excel training course and other Microsoft training courses.

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips