Forum home » Delegate support and help forum » Microsoft Excel Training and help » Format Painter

Format Painter

ResolvedVersion 2003

Mon 29 Sep 2008, 15:34 Delegate Heather said...

Heather has attended:
Excel Introduction course

Format Painter

How to make effective use of this tool

Mon 29 Sep 2008, 17:00 Trainer Amanda said...

RE: Format Painter

Hello Heather

Thank you for your question.

The Format Painter is a 'copy and paste' for formatting.

So for example if you have formatted a cell containing a number to have decimal places, a pounds sign and have added borders to the cell and you want another cell or cells containing numbers to look the same, you can use the format painter to copy the formats from one cell to others.

I hope this helps.
Amanda

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips

Format Painter

Format Painter

RE: Format Painter

Excel articles

Excel tip:

Generate randon numbers