Home Sample Files e-Books Books Wholesale Forums & Support Contact
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Use the Format Painter:

Lesson 4-23 from: Microsoft Excel 2016 Essential Skills (138 Video Lessons)
This video walkthrough does not have voice narration. It is intended to be used as a supplement to the printed book or e-book.
You can purchase the books and e-books by clicking here.
Use the Format Painter
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Back 10 Seconds
Full Screen View
Online Video Course: Microsoft Excel 2016 Essential Skills
Session: Session 4: Making Your Worksheets Look Professional
Lesson: Lesson 4-23 Use the Format Painter Excel copy format. Thumbnail from Excel 2016 Essential Skills Lesson 4-22 Use the Format Painter.

This video lesson shows How to Use the Format Painter in Excel 2016. You will use the format painter to copy formatting from the values in one cell to values in another cell (or cells) in an Excel worksheet. You'll learn to use the Format Painter as both a one-time format copier and as a "sticky" format painter to copy formatting from one worksheet cell to a number of other worksheet cells in different locations. You'll also discover a Paste Special option that can achieve the same results as the format painter. Finally you'll find that AutoFill can also be used to copy formats from one Excel worksheet cell to another.