Apply Multiple Formatting Using Format Painter Found In Microsoft Excel, PowerPoint, Word and Outlook


We spend a lot of time making our Excel spreadsheets look good. At times someone else has done the hard work picking the correct colour, font, size etc and all you may be wanting to do is to re apply exactly what they have done. First select the text that already has the formatting you want, go to the Home Tab and select “Format Painter“. This is where most people say, yeh, yeh I know what to do. Well I bet you pressed the Format Painter BUT only ONCE. Ok, try this click on the Format Painter TWICE, get trigger happy  (DOUBLE CLICK) it instead. The Format Painter will now stay on so you can apply to other text. When you would like to stop press the Format Painter again or press ESC.

Try the “Format Painter ” tool. This video below will take you through step by step.

Format Painter Tool In Microsoft Excel

How To Widen Columns In Microsoft Excel

There are several techniques you can use to widen the columns in Microsoft Excel. You could double click between the column letters. You will need to ensure you are getting a mouse pointer with a skinny little cross not the down arrow that will select the entire column. If you need to widen a column to a specific width, keep in mind the width is in characters not cm or mm or pixels. Steps: Position your mouse pointer between the column letters until you have the skinny little cross and then drag you will see the numbers display. If you want to be even more specific you can Right Mouse Click instead and select column width, then type the amount eg 20 . Watch the video below for a demo.

Microsoft Office Small Group Training Sessions

AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.

Call Now M 0414 417 059 visit www.azsolutions.com.au

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel, Outlook, Power Point, Word and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s