Common questions about Format Painter usually involve permissions, formatting scope, and how to exit repeated-use mode; this FAQ includes 3 common answers and a glossary.
FAQ
Why is the Format Painter button grayed out?
- Check whether the current file is editable.
- If you only have view permission in a shared spreadsheet, ask the owner or collaborator for edit permission.
- After edit permission is granted, reopen the file and check the Format Painter button on the Home tab again.
Can Format Painter copy conditional formatting?
- Format Painter can copy basic cell formatting such as font, color, border, and fill.
- Conditional formatting rules are not included in the basic copy scope described here.
- If the target range needs the same conditional formatting, set those rules again for the target range.
How do I exit repeated-use mode?
- After using Format Painter repeatedly, press
ESCto exit. - You can also click Format Painter again to turn the mode off.
- After that, clicking cells returns to normal selection behavior.
Glossary
| Term | Definition |
|---|---|
| Format Painter | A tool that copies and applies cell formatting without copying content or formulas. |
| Repeated-use mode | A mode entered by double-clicking Format Painter so you can apply the same formatting to multiple ranges. |
| Edit permission | The permission required in a shared file to modify content and formatting. |