The Format Painter in Excel makes it easy to copy the formatting of a cell and apply it to another. With just a few clicks you can reproduce formatting such as fonts, alignment, text size, border, and background color.
On any Excel worksheet, click on the cell with the formatting you’d like to copy. You will see dashed lines around the selected cell. Then select the Home tab and click on the Format Painter.
You’ll see your cursor now includes a paintbrush graphic. Move to the cell where you’d like to apply the formatting and click on it.
Your target cell will now have the new formatting.
If you double-clicking on Format Painter you can then click on multiple individual files to which to apply the format. Or, you can click and drag across a group of cells. When you are finished applying formats, click on Format Painter again, or on the Esc key, to turn it off.
The Format Painter is a very simple, but extremely useful and time saving tool when creating complex worksheets.