Feb 19, 20222 min read

Microsoft Excel - The Format Painter

If you've spent forever perfecting the formatting of one section of your Microsoft Excel spreadsheet, why waste time recreating it elsewhere? The Format Painter tool is going to become your new best friend! Here's how!

Location:

Home Tab > Clipboard Group

Keyboard Shortcut:

We all love to make our Microsoft Excel Spreadsheets look beautiful, right? Sometimes, we will spend hours in the pursuit of perfection, chasing the ideal shade of blue or the idyllic font combination that will help make our little hearts soar!

Or is that just me?

Anyway...

Once those design considerations have been made, it can be almost impossible to recreate the magic elsewhere in our spreadsheet. We might miss-match that blue, or the font will be just a little off-kilter.

Enter the Format Painter!

This tool enables you to 'steal' your formatting from one location, and paste it elsewhere!

Check out the video below to see this in action:

Effortless isn't it?

The benefits of the Format Painter for ensuring consistency in design, maintaining professionalism and fixing any 'not quite perfect' aspects of your spreadsheets are pretty clear to see.

But it's the gift that just keeps giving!

If you give the Format Painter a double-click, it 'sticks on' and enables you to paste the formatting in numerous locations.

Watch the video below to see what I mean by this:

Ok, so I might have got a little carried away with this one, but hopefully, you will appreciate just how awesome this cheeky Microsoft Excel tool is!

It's one I tend to use on a daily basis, and one I hope you will find just as handy when you are creating your very own grid-based works of art!