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.

Transcript

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

Microsoft takes the pain out of updates

Microsoft takes the pain out of updates with checkpoint cumulative updates

Updates are a pain, right? Time consuming and disruptive. Not anymore… Here we tell you how Microsoft’s latest Windows 11 update is making things quicker and easier.

Businesses are taking too long to fix vulnerabilities

Businesses are taking too long to fix vulnerabilities

If you knew your systems were at risk of attack, you’d jump in and get things locked down fast – right? Actually… many businesses take too long to fix vulnerabilities. Here’s why that’s a problem.

Ransomware Attacks Grow for Small Businesses

Two organisations have recently released reports on the state of ransomware and cybersecurity incidents affecting small businesses. Datto's State of the Channel Ransomware Report Datto has recently released their "State of the Channel Ransomware Report"  for 2019...

The hidden risk of unsupported software

It’s surprisingly common for businesses to rely on unsupported software. Not because anyone is careless or willing to take unnecessary risks. More often, the software has simply been in place for years. It still works. Your team knows how to use it. And replacing it...
Windows 11’s new focus on efficiency

Windows 11’s new focus on efficiency

What if the biggest productivity boost for your team isn’t a new tool but a smoother experience with the tools they already use?
Tiny delays, cluttered screens, systems that feel a little sluggish don’t seem like much. But over weeks and months, they eat into efficiency.
These Windows 11 updates will make everyday work feel cleaner and faster…

Tech Tip: How to use Conditional Formatting in Excel

This Tuesday Two Minute Tech-tip shows you how to automatically add pizzaz to your spreadsheets. Using a feature called 'Conditional Formatting', you can automatically format the cells of your Excel spreadsheet based on what is in them. For example, you can emphasise...

90% of cyber attacks start with a simple email. Why?

All it takes is one email... Did you know it can just take one email to bring your entire business to its knees? Why? Because a surprising 90% of cyber attacks begin with an email. And if you and your whole team are reliant on email every day, your chances of falling...

Is your business data at risk? Don’t take chances with old tech

Old computers and external drives can put your sensitive business data at risk.
We look at how to dispose of old computers and external drives in the safest way possible.

Getting to Grips with Email Security

Owners of small and medium-sized businesses often make the mistake of thinking that they aren’t on the criminals’ radar. But more than 40% of cyber attacks are aimed at small businesses – and email is usually the criminals’ way in. Our new guide, ‘Getting to Grips...
Unwrap the gift of knowledge: 5 free AI courses by Microsoft

Unwrap the gift of knowledge: 5 free AI training courses by Microsoft

Microsoft has a little business-boosting gift that you won’t want to miss out on… five free courses about AI. We have the details, and the links to the courses.

Share This
Contact
Love Lane
Cleobury Mortimer
Shropshire DY14 8PE

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