Excel FormattingLesson 22Free preview

Excel Format Painter

This lesson is part of Excel · All levels

Summary

Painter format copies the appearance of a cell such as font, color, and border to another cell without touching the contents. One click is used for a single use, while a double click locks the tool so that it can be used repeatedly in many areas. The Ctrl+Shift+C and Ctrl+Shift+V crossovers speed up the same workflow without having to reach the icon.

Key points

The Painter format only copies the format, not the value or formula
Double-click the icon to lock the repeated use
Press Esc or double-click the icon to exit the mode
Ctrl+Shift+C copying the format, Ctrl+Shift+V pasting it

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.