A tool that copies formatting from one cell or range and applies it to another.
AI で試すThe Format Painter allows you to quickly replicate visual attributes such as font style, color, borders, and number formatting without changing the cell content. By selecting the source cell and clicking the tool, you can paint the desired style onto any other target cell or range.
If you have a header cell with bold blue text and a yellow background, select it, click Format Painter, and click another cell to instantly apply those same styles.
Double-click the Format Painter icon to keep it active, allowing you to apply the format to multiple non-adjacent cells until you press the Esc key.