Hide

Formatting cells:
Using the Format Painter

You can download here the worksheet from this video to practice it by yourself!

What is the format painter good for?

It can save you a lot of time when formatting and styling your data.

Use it whenever you want to apply the same format on other areas of your data.

Pay attention – the format painter doesn’t change the data itself, only its visual appearance.
Therefore, I usually type my data and leave it “raw” and unformatted.
When I finish, I format a small portion of it, and I copy it to all the rest of the data using the painter.

You can see in this video a simple demonstration of how to use it.
After watching you can try it yourself by clicking the link that is under the video.