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

microsoft excel courses - format painting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Format painting

microsoft excel courses - Format painting

ResolvedVersion Standard

Cathy has attended:
Excel Intermediate course

Format painting

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

RE: Format painting

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

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

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.14 secs.