How do you use Format Painter button for formatting multiple cells or multiple times?

Apply Formatting Multiple Times

First of all, select the range from where you want to copy formatting. After that go to Home Tab → Clipboard → Format Painter. Now, double-click on the format painter button. From here, you can paste the formatting multiple times.

How do I mass format painter in Excel?

The Format Painter copies formatting from one place and applies it to another.

1. For example, select cell B2 below.
2. On the Home tab, in the Clipboard group, click Format Painter. …
3. Select cell D2. …
4. Double click the Format Painter button to apply the same formatting to multiple cells.