Question

how to use format painter multiple times?​

Answer 1

If you want to apply the formatting to more than one element, double-click the Format Painter instead of single-clicking it. Click and drag over the item(s) you wish to “paint” with the formatting. If you double-clicked the Format Painter in step 2, click it once more or press the Esc key to deactivate it.

Answer 2

Answer:

1.Select the cell

2.Double-Click the Format Painter Icon

Note: This will keep the paint brush next to your cursor: 

3.Click every cell you want to copy the format to

4.When finished, click the Format Painter icon again or hit ESC to remove the paint brush from your cursor