How to Copy Cell Formatting from a Given Cell to Another Cell or a Range

How to copy cell formatting from a given cell to another cell or a range? You can select all cells and choose the format, but you can also use the Excel Format Painter to make it easier, especially if you don’t know the formatting settings for a given cell.

What is Format Painter in Excel

The Excel Format Painter is a tool in Microsoft Excel that allows you to copy the formatting of one cell, range of cells and apply it to another cell, range of cells, or object in your worksheet.

How to copy cell format from one cell to another cell 1.png

Copy Formatting from a Cell to Another Cell or Range by Format Painter

To copy the format from a cell to another cell or range, you can follow the steps below:

Step1: Select the cell or range of cells that you want to copy the formatting from. In this example, select the cell B1.

Step2: Click on the “Format Painter” button in the “Clipboard” group on the “Home” tab of the ribbon.

How to copy cell format from one cell to another cell 2.png

Step3: The cursor will change to a paintbrush icon.

Step4: Click and drag the paintbrush cursor over the cell or range of cells where you want to apply the formatting. In this example, the cells are B3:B7.

Step5: Release the mouse button and the formatting will be applied to the selected cell.

How to copy cell format from one cell to another cell 3.png

Cells Have Different Formatting

If the given cells have different formatting, the formatting will be inherited by corresponding cells.

How to copy cell format from one cell to another cell 4.png

Clear the Formatting Copied From a Given Cell

You can also double-click on the Format Painter button to apply the formatting to multiple areas without having to click the button again each time. And if you want to clear the formatting from a cell, you can use the “Clear Formats” option in the “Clear” dropdown on the “Home” tab.

How to copy cell format from one cell to another cell 5.png

Conclusion

This article is easy to understand and it is typical example about Format Painter. Applying Format Painter to copy formatting from a given cell or range to other cells or ranges is time-saving, and you don’t need to manually adjust the formatting or the given formatting is unclear.

Leave a Reply

Your email address will not be published. Required fields are marked *