Excel: Power Up Format Painter

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


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

  1. 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.

  2. Three format painter clicks copies the format three times.
    1. When you are done copying formats, you need to exit Format Painter mode. Either press Esc or click the Format Painter again.

For more resources for Microsoft Excel