99.1% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
The Format Painter: Office's Wonder Tool
Mon 24th January 2011
The format painter in Microsoft Office is something of an electronic equivalent of those magic painting books in that it allows the user to format text at a stroke, without the need to go back and forth. It really is one of the most useful tools in Office and yet it is still quite often mistaken for a paste brush. The format painter icon sits on the Standard toolbar in Word, Excel, PowerPoint, FrontPage, and Access (it is on the left of the Home ribbon in 2007 versions and so on), and it is in the shape of a paintbrush. So how does it work?
Let us say you have a Word document with headings at the top of each paragraph. You want these headings to stand out and so you apply formatting. For example you choose a different font, make the text bold and change the colour to red. Without the format painter this would be a time-consuming task where each heading would have to be selected and then the desired formatting individually applied. The format painter allows you to 'paint on' the formatting you choose.
Highlight the text of your first heading and format it as you want. You are now ready to use the format painter - but first a word about clicking. If you click on the format painter icon once only, then the resulting function will be applied only once as well. If you double click on the icon the format painter will then apply the selected formatting as many times as you like until it is switched off.
So with your first heading formatted just as you want it, highlight it and double click the format painter icon. You will notice that a small paintbrush appears alongside your cursor. This brush is now loaded with the formatting of your highlighted heading and as you select the rest of the headings one at a time, the same formatting is applied to each one.
The format painter is not restricted to use in Word, it can also be used in other Office applications. It is particularly useful in Excel, where extra columns and rows are often added that will require formatting. The process is exactly the same as for Word in that you select the cell that you want to copy the formatting from and click the paintbrush icon (remember, once for a single use and twice for multiple ones). Then click on the cells to which you want the formatting applied.
There are many other ways that Microsoft Office can take care of the minor tasks so that you can get on with the major ones and they are worth discovering. The format painter is one of those tools that, once discovered, will be called upon regularly. I know that when I first came across it I spent as much time experimenting with it as I did with those magic painting books as a child.
Original article appears here:
London's widest choice in
dates, venues, and prices
On-site / Closed company:
Dishman Europe Ltd
Introduction to Management
Very good topic, perhaps I would extend the time spent on how to motivate people. I would also add more simulations of scenarios where people can interact between each other
Institute of Biology
Very informative course
The course helps you learn some of the often missed functions of excel.