microsoft excel courses - Format painting

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

Resolved · Low Priority · Version Standard

Format painting

Cathy has attended:
Excel Intermediate course

by - delegate Cathy [1 post] (2007 Jun 28 Thu, 13:30) Reply

What is the difference in using a format painter and setting styles?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Format painting

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 10:52) Reply

Hi Cathy,

Thanks for the question.

The format painter simply copies the format of the cells, for example if it has a red font it will copy that red font to another cell.

Styles do a very similar thing, except they are stored in the computer so you can use them over and over again. (Under Format>Style)

I hope that makes sense

Tracy

· Do You Really Need Excel VBA Training?
· Interesting Lifestyle Applications for Microsoft Excel
· How to check for and reduce errors in Microsoft Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Improve Performance Of Your Excel Macros

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