Format Painter In Excel

The simple idea with the format painter is to copy and paste formatting from one section to another. Let’s say you have specific formatting (Font Style and Color, Background Color to a Cell, Bold, Border, etc.) in the range B2:D7, and with format painter, you can copy that formatting to range B9: D14 with a click.

1. First of all, select the range B2:D7.
2. After that, go to the Home Tab ➜ Clipboard and then click on “Format Painter”.
3. Now, select cell C1 and it will automatically apply the formatting on B9: D14.

The format painter is fast and makes it easy to apply to format from one section to another.