MrExcel.com - Your One Stop for Excel Tips & Solutions

Power Up Format Painter

October 11, 2023 - by

Power Up Format Painter

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

A report made up of a series of mini-reports. Each mini report is four rows and 2 columns. The first of several mini reports is nicely formatted and you have to apply similar formatting to the others. Select A1:B4 an double-click the Format Painter icon.
Figure 1362. 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.

Touch each of the other mini-reports with the Format Painter cell icon to quickly format them.
Figure 1363. 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.

This article is an excerpt from Power Excel With MrExcel

Title photo by Amos Bar-Zeev on Unsplash