Format Painter

One of the quickest ways to format text or objects in Word, Excel, and PowerPoint is with the Format Painter. For example, if you have several lines of text in a Word document that you want to look the same, it can be a hassle to format each line of text individually. So, after you have formatted the first line of text, you can copy that formatting with the Format Painter and apply that formatting to the other text lines. The Format Painter works the same in Excel, Word, and PowerPoint.

How to use the Format Painter:

1. Format one of the objects, cells, or lines of text
2. Select the object or cell (or highlight the line of text)
3. Select the Format Painter button (located on far left corner of the Home tab)
4. Select the unformatted objects or cells (highlight the unformatted lines of text)

This method allows you to format objects one at a time. If you have multiple objects that need to be formatted, simply double-click on the Format Painter button in step 3 (see steps above). The Format Painter stays on so you can apply formatting to multiple objects, cells, or lines of text. Then, when you are finished, de-select the Format Painter button.

The Format Painter is an awesome tool that will save you time and effort as you make your format your documents, presentations, and spreadsheets.

Learn more tools and shortcuts for Microsoft programs in our fun classes! Click here to register.