Copying Cell Format From One Cell to Another in Excel 2007
The quickest way to copy the formats from one cell to another cell or range is to use the Format Painter button in the Ribbon's Home tab.
Follow these steps:
1) Select the cell or range with the formatting attributes that you want to copy.
2) Click the Format Painter button. Notice that the mouse pointer appears as a miniature paintbrush.
3) Select (paint) the cells to which you want to apply the formats.
4) Release the mouse button, and Excel copies the formats.
TIP:
Double-clicking the Format Painter button causes the mouse pointer to remain a paintbrush after you release the mouse button. This paintbrush enables you to paint other areas of the worksheet with the same formats. To exit paint mode, click the Format Painter button again (or press Esc).
Related Articles