microsoft excel courses - format painting

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

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

microsoft excel courses - Format painting

resolvedResolved · Low Priority · Version 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:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips


Server loaded in 0.08 secs.