Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-advanced courses - Comment boxes

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel-training-advanced courses - Comment boxes

Resolved · Low Priority · Version Standard

Reply Thu 20 Dec 2007, 17:01Delegate Calum said...

Calum has attended:
Excel Intermediate course
Excel Advanced course

Comment boxes

How do I print out comment boxes?

For upcoming training course dates see: Pricing & availability

Reply Wed 2 Jan 2008, 09:27Trainer Rajeev said...

RE: Comment boxes

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

Reply Wed 2 Jan 2008, 09:43Trainer Rajeev said...

RE: Comment boxes

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

Reply Fri 4 Jan 2008, 14:21Delegate Calum said...

RE: Comment boxes

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

Reply Sun 6 Jan 2008, 01:53Trainer Rajeev said...

RE: Comment boxes

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

Excel articles

· How To Disguise Error Messages In Excel 2007/2010
· Which Is Better, Excel Or Access?
· So Why Are There So Many File Types In Excel 2007?
· Spreadsheets: What's In A Name?
· Some Simple Yet Less Common Excel Functions

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips