When you are building a professional financial dashboard in Microsoft Excel, you spend a massive amount of time applying custom formatting. You might format a specific header cell with a deep blue background, bold white Arial text, a thick black border, and a specific currency alignment. If you need to apply that exact same aesthetic to thirty other random cells scattered across your workbook, doing it manually would take hours. To instantly clone complex formatting from one cell to another, you must use the Format Painter tool.
How the Format Painter Works
The Format Painter does not copy the actual data (the words or numbers) inside a cell. It acts like a digital sponge, absorbing only the aesthetic shell—the colors, fonts, borders, alignments, and number formats—so you can “paint” that shell onto other cells.
- Click once on the beautifully formatted Source Cell (the cell that looks exactly the way you want).
- Look at the top-left corner of the Excel ribbon, under the Home tab.
- In the “Clipboard” group, click the Format Painter icon (it looks like a small yellow paintbrush).
Your mouse cursor will immediately change to include a tiny paintbrush icon next to the standard white cross. The Source Cell will also be surrounded by a moving, dotted green line (the “marching ants”).
Simply click once on any unformatted Target Cell. The target cell will instantly adopt the exact colors, borders, and typography of the source cell, while completely retaining its original raw data.
How to Paint Multiple Cells Continuously
By default, the Format Painter is a single-use tool. Once you click a target cell, the paintbrush disappears, and your cursor returns to normal. This is incredibly frustrating if you need to format 20 different headers across 5 different worksheets.
To lock the Format Painter into continuous mode:
- Click your perfectly formatted Source Cell.
- Double-click the yellow Format Painter icon on the ribbon.
The tool is now permanently locked on. You can now aggressively click (or click and drag) across hundreds of different cells, columns, and even entirely different worksheets, painting the formatting everywhere you go. The tool will not turn off until you physically press the Esc key on your keyboard, instantly saving you hours of tedious, repetitive design work.