USE FORMAT PAINTER

Prev Show Me Step-By-Step Next
Get Ready
Identify a cell containing a format you want to copy.
Example: A3
Locate the cell or range of cells you want to reformat.
Example: C5

Begin
Click the cell with the format you want to copy.
Click the button.
Click the cell or cells you want to reformat.

Note: You can double-click the Format Painter button to continue painting formats.