How to Use Format Painter for Multiple Cells in Excel (7 Methods)

We have a dataset of a List of Fruits and Their Colors. We will use Format Painter to copy the cell format.

Method 1 – One-Click Process to Use the Format Painter in Multiple Cells in Excel

Steps:

Select the entire data range that you want to format.
Press Ctrl + C to copy the cells.
Navigate to the Home tab and choose Format Painter from the Clipboard section.
The mouse cursor will turn into a paintbrush. Click on the cells where you want to put the format.

The Color column will turn into the same color as the image below.

We have attached a GIF of the full process of this method for better visualization.

Steps:

Select the data range where you want to copy the formatting.
Go to the Home tab and choose Format Painter from the Clipboard section by double-clicking on it.
Paste the format to your desired multiple columns and get the following outputs.

Steps:

The Go To dialog box appears. Put the data range D5:D9 in the Reference box as we want to paste the formatting there.
Hit OK.

The formatting is done to your selected cells automatically like the image below.

Case 1:

Case 2:

Steps:

Here’s the result.

We have a worksheet where we highlighted the Project amounts greater than $2,000. We want to set the same conditional formatting in column E.

Steps:

Select any of the columns where the Conditional Formatting exists and go to the Format Painter.
Click on any cell of the required column where you want to put the formatting. You will get a proper idea by seeing the GIF below.

Here’s the result.

We have to format the Right shape according to the Left one.

Steps:

Choose the Left shape and click on the Format Painter from the Home tab.
Select the shape that we want to format.
The Right shape is formatted like the Left one.