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