Click the cell with the formatting that you want to copy and apply to other cells.
Click the Format Painter button on the Standard toolbar; the mouse pointer changes to a Format Painter pointer (paintbrush symbol).
Select the cells to which you want to apply the copied formatting.
Release the mouse button. The formatting is applied to the data in the selected cells.
INTRODUCTION
If you have taken the time to format a specific cell just so, you might decide you want to apply those same formatting options to other cells. Instead of repeating each step in the format process over and over again, you can simply use Excel's Format Painter feature.
TIP
Removing Cell Formatting
To quickly remove any cell formatting, select the cells you want to return to their default settings; then open the Edit menu and select Clear, Formats.
