The Format Painter icon (with a paintbrush icon) in the Home tab’s Clipboard group adds style from the current cell to cells users “paint” by moving its distinctive thick-white cross-plus-paintbrush mouse pointer through them. As a result, this tool makes it simple to take a variety of various formats (such as a new font, bold, font size, and italics) that you apply separately to a cell in the spreadsheet and then use them as a template for styling a new range of cells.
Follow these instructions to use the Format Painter:
1. Place the cell pointer in a cell with the formatting you want to copy to another group of cells in the worksheet.
This cell becomes the example cell, and the formatting is duplicated into the cells that Format Painter “paints” with its special mouse cursor.
2. On the Home tab of the Ribbon, select the Format Painter icon (with the paintbrush icon) in the Clipboard group.
Excel adds a paintbrush icon to the typical thick white-cross mouse cursor when you click this button, indicating that the Format Painter is set to copy the formatting from the example cell.
3. Move the mouse pointer over the range of cells you wish to format the same way as the sample cell.
The cells in the area you just chose with the Format Painter become styled in the same way as the sample cell as soon as you release the mouse button.