How to Use the Excel 2013 Format Painter
Position the cell cursor in a cell that contains the formatting that you want copied to another range of cells in the spreadsheet.
This cell becomes the sample cell whose formatting is taken up by Format Painter and copied in the cells that paint with its special mouse pointer.
Click the Format Painter button (with the paintbrush icon) in the Clipboard group on the Home tab of the Ribbon.
As soon as you click this button, Excel adds a paintbrush icon to the standard thick white-cross mouse pointer, indicating that the Format Painter is ready to copy the formatting from the sample cell.