98.3 % recommend us More live stats... RSS feeds What's this? All hints and tips: Only Excel hints and tips:

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:

• Create and delete borders
• Turn Function tooltips on and off
• Move to edge of data block

Using Office For Simple Research Tasks This article explores how to use office to create and analyse a survey and its data. » Article: Microsoft office

How do i import a Gantt tracking chart into a MS Powerpoint slide? » Forum post: MS Project