Quick Answer: How Do You Hold Format Painter?

You do this by first clicking on or selecting the source of the formatting, and then double-clicking the toolbar button. The Format Painter will remain in this locked position until you unlock it.

How do I lock the Format Painter in Excel?

Step 1 – Double-click the Format Painter button. This will lock the format painter and allow you to select multiple cells or objects to apply formatting. When finished, press the Escape key on the keyboard or press the Format Painter button again.

How do I use format painter?

Use the Format Painter

1. Select the text or graphic that has the formatting that you want to copy. …
2. On the Home tab, click Format Painter. …
3. Use the brush to paint over a selection of text or graphics to apply the formatting. …
4. To stop formatting, press ESC.