How to use the Format Painter in Excel
to Copy Formatting – in 2 Clicks!
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Cell formatting is very useful.
It makes you spreadsheet user-friendly and awesome to look at!
In addition to making your spreadsheet nicer to look at, you can conditionally format cells, use formats in your searches, and even filter by format.
These features are great…
… but sometimes you just want to get a lot of cells formatted quickly, and they can’t help you there 🙁
What you need is the format painter! 🙂
*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.