This FAQ covers 3 common questions about Format Painter on iOS, including what it copies, what stays unchanged, and how to recover after clearing formatting.
FAQ
Can Format Painter copy formulas?
- Format Painter only copies cell formatting.
- It does not copy formulas, text, or numeric values.
- If you need to copy formulas, use regular copy and paste or a fill-related action instead.
Why did only the style change after I pasted the format?
- This is expected because Format Painter changes formatting only.
- The original content in the target cell stays in place.
- If you need to copy both content and formatting, use regular copy and paste.
Can I recover after using Clear Format?
- If you just cleared the formatting, try Undo first.
- Check whether the previous cell style returns after undoing.
- If several other edits were made afterward, apply the needed formatting again.
Glossary
| Term | Definition |
|---|---|
| Format Painter | A tool that copies and applies formatting without copying the cell content itself. |
| Copy Format | Captures the existing formatting from a source cell for reuse. |
| Paste Format | Applies the copied formatting to a target cell or range. |
| Clear Format | Removes existing formatting from the selected range while keeping the content. |