Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel-training-advanced courses - comment boxes

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

excel-training-advanced courses - Comment boxes

ResolvedVersion Standard

Calum has attended:
Excel Intermediate course
Excel Advanced course

Comment boxes

How do I print out comment boxes?

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

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

RE: Comment boxes

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

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 tip:

Checking formulas with multiple operators

When dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right:

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.