Tech Tip: How to use Format Painter in Office 365 • Blisstech Solutions

Welcome to a new Tuesday tech tip video where we will show you how to use a feature of Office applications called Format Painter.

If you want to know how to quickly make the content of your Office documents look consistent, then this video will show you how. Format Painter in Word, PowerPoint and Excel will save you loads of time and stress when getting your documents to have consistent and professional formatting.


Hello everyone and welcome to another edition of Blistech Solutions Tuesdays Tech Tips.

In today’s tech tip, I’m going to talk to you about the format Painter which is available in Microsoft Office applications.

You can use it in Word, Excel and PowerPoint and it can be really useful if you want to update the format of a particular part of your document to be consistent with other things.

So, if you ever worked in Word, you know, if you use Word a lot, you’ll be familiar with this where there are some things that just don’t look quite right. You might have copied and pasted it from an existing document. You might have inherited the document for somebody else, but the formatting is all over the place and it looks pretty awful.

Incidentally, the best practice way of doing this is to use styles and update the styles, because they will automatically update when you change the style. But that’s for another day.

So, if you quickly want to do this… we’ve got a document here and you can see most of this is consistent, but then we get down here and the formatting is all over the place.

If we want the rest of this document to have the same formatting as what we’ve got at the top, we go to the top left-hand corner of Word (It’s the same in Excel and PowerPoint) and we’ve got Format Painter.

Make sure that we’re in the area where we want to copy the format from and click format painter and then literally drag across the content you want to change, and it will update it. And that’s a quick way that we can easily make a document consistent.

The same goes for bullet points. We’ve got these fancy bullet points here and we can’t remember how we set them up. So, you’re going to click on Format Painter making sure that the bullet point is selected, and then highlight the areas you want to have bullet points, it will create the same exactly the same formatting in that area. I hope you found this tip useful. I’ll see you again next time.

We hope you found this tip useful.  If you want more tech tips, take a look at our Learning Zone.

More Content

How to use footnotes and endnotes in Word

Tech Tip: How to use footnotes and endnotes in Word

This Tech Tip is another tip for Microsoft Word. If you use Word to write documentation, contracts or any other type of detailed document, then this tip is for you. Usually, when you write such a document, you may need to expand on certain sentences without making the...

How to scan a QR code with your phone

As more venues open up for face to face meetings, some are introducing their own track and trace systems using a QR code that you need to scan with your mobile phone. But how? This video explains how to scan a QR code with your phone so you are not trying to figure it...
Logos for Microsoft 365

The Microsoft New Commerce Experience (NCE) is on the way

Microsoft is introducing what it calls a New Commerce Experience (NCE) in 2022, with changes to licensing terms and pricing for Microsoft 365. This will mean fairly big, and potentially expensive, changes for business customers who have Microsoft 365 licences. The...
Are your employees reporting security issues fast enough… or even at all?

Are your employees reporting security issues fast enough… or even at all?

The faster your employees report a potential cyber security issue, the less damage is done to your business. But how can you encourage quick reporting? Here we share some solid ideas.

How to disable fast startup - thumbnail image

Tech Tip: How to disable Fast Startup and shutdown your computer properly

It is a fact of life that we occasionally have to turn our Windows computers off and back on again to fix problems.  However, if you are not shutting down your computer fully then your efforts may not have the desired effect because of a feature called Fast Startup....
A person in a hoodie surrounded by green cipher text

3 Things You Must Do to Protect Against Ransomware

Ransomware is an increasingly common and devastating cyberattack that can happen to any business. The ransomware attacks that get the most media attention are those on high profile companies, but ransomware attacks on small businesses are increasing too. Many smaller...

Tech Tip: How to create a scheduling poll using Outlook

Welcome to a new Tuesday tech tip video where we will be exploring how to create a scheduling poll using Outlook. You know what it's like when you are trying to get everyone together for a meeting. Trying to find a time that suits everyone can be a real pain! There...

3 things you should do now to protect your business email

It's a fact, most cyber attacks start with an email.  In fact, a frightening 91% of attacks begin with someone clicking on something they shouldn't in an email they received. Here are three things you can do now to protect your business and make it harder for...

Tech Tip: How to use a Password Manager

This Tech Tip is a tip on how to manage your passwords. It's a long tip this week, but that's because there is a lot to tell! With so many things being done online now, passwords are needed constantly.  But with the advice that every password should be unique and not...
Managed IT Services consultant connects a network cable into switch

What are the benefits of outsourcing IT support?

Have you ever started a DIY task only to wish you had just called in an expert?  Your IT support should be no different. Many business owners think that they can handle their IT systems themselves.  However, unless they have the experience and finger on the pulse of...
Share This
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

01299 382 321
[email protected]
Copyright © 2023 Blisstech Solution Ltd
Registered No: 08125391 VAT No : 307 5490 05