Easy and Quick Formatting
By Neale Blackwood
One of the more useful toolbar icons is the Format Painter. It looks like a yellow paintbrush. It allows you to click on a cell that has a format you want to use and then click the Format Painter (notice that the mouse cursor shape turns into a paint brush) and then click the range where you want to paste the format. When you single click the Format Painter it only allows you to paste once.
If you double click the Format Painter then you can paste as many times as you want. The mouse cursor will stay in the paint brush shape after you have double clicked the Format Painter. Press the Esc key or click on the Format Painter icon again to reset the cursor.
In Excel 2007 this feature is in the Home Ribbon tab under The Clipboard section.