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.
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.
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.
Cells Have Different Formatting
If the given cells have different formatting, the formatting will be inherited by corresponding cells.
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.
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.