Most valuable professional
  • Excel Book Excerpt

Excel Power Up Format Painter

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Power Up Format Painter

Problem: I have to paste formatting to many sections of a report.


Figure 1213 Double-click the Format Painter.

Here is an example:

1. Select the original range and double-click the Format Painter icon. The Format Painter icon will stay lit. The mouse pointer is a paint brush.

2. Click the top-left cell of the first destination range. As you click each top-left cell, the formats from the entire original range will be copied to a similar-shaped area.


Figure 1214 Three format painter clicks copies the format three times.

3. When you are done copying formats, you need to exit Format Painter mode. Either press Esc or click the Format Painter again.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: