excel-training-advanced courses - Comment boxes

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

Resolved · Low Priority · Version Standard

Comment boxes

Calum has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Calum [5 posts] (2007 Dec 20 Thu, 17:01) Reply

How do I print out comment boxes?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Comment boxes

by - trainer Rajeev gold contributer [462 posts] (2008 Jan 2 Wed, 09:27) Reply

Dear Calum

Thanks for attending Excel Course.

This is a very interesting query as it is quiet straight forward to insert , edit and delete a comment. You simply have to right-click on the cell that you wish to insert the comment and then choose the relevant option.

To print the comments is however is not that straightforward. Having said that it is not that difficult either. There are two options that you are given when printing comments.

Step 1: First if you wish to print the comments as they appear on the screen then right-click on the ones that you want to print and choose show/hide comments.
Step 2: Then choose File> Page setup> select the Sheet Tab.
Step 3: Under the print section on the comments drop down list choose “As displayed on sheet” . The comments will be printed as text boxes as displayed on the screen.

NB: Please note that by choosing this options there is a possibility that some of the data on your worksheet may be obscured, especially if you have lots of comments to print. It is possible to drag the comments to empty areas of the worksheet.

The other option is to print the comments at the end of the worksheet. MS Excel will insert a separate page displaying the cell reference and the comment along with eth author.

For this option you do not need to display the comments on the screen. Follow step 2 as mention above and in step 3 choose “at end of sheet”.

I hope this has helped in answering your query.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003

RE: Comment boxes

by - trainer Rajeev gold contributer [462 posts] (2008 Jan 2 Wed, 09:43) Reply

Dear Calum

In addition to my previous reply. Please always preview to see how the comments will be printed and then choose File > Print... to complete the print process!!

Thank

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003

RE: Comment boxes

by - delegate Calum [5 posts] (2008 Jan 4 Fri, 14:21) Reply

Many thanks for your advice, most helpful.
Regards,
Calum

RE: Comment boxes

by - trainer Rajeev gold contributer [462 posts] (2008 Jan 6 Sun, 01:53) Reply

Dear Calum

I am glad that you found the advice helpful!!

Can I please request you to mark this question as resolved?

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor

· Fun Things I've Done With Excel
· Microsoft Excel Training Course
· Advanced Excel and PivotTable Reports
· MS Excel: Excel At Making The Most Of Your Christmas
· From the Classroom to the Corporate World

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips