Hints and tips home » Excel hints and tips » Use the Format Painter to copy formatting more than once in Excel

Use the Format Painter to copy formatting more than once in Excel

The format painter tool provides a quick and easy way to copy formatting from one cell to another in Word.

The only problem is that if you click the Format Painter once to turn it on, you can only click and drag over a single cell or adjacent range of cells; then the Format Painter turns itself off automatically.

If you want to copy formatting to cells or groups of cells that are not adjacent to each other, double-click the Format Painter - this way you will be able to copy formatting to multiple cells.

When you have finished using Format Painter, press the Esc key or click on the Format Painter button once to turn it off.

Added by Amanda on 25th November 2006

More Excel hints and tips, like:

• Colouring cells containing formulas
• Adjusting the Elevation and Rotation in a 3-D Chart
• Creating custom lists