Copy a cell formatting from one cell to other cells in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Have you ever been there before, when there is a cell has exactly the formatting which you want to apply to other cells in Excel? That's for sure, and we can use the Format Painter to quickly copy formatting from one place and apply it to another. But how about copying specific formatting from one place and apply it to other cells? That's why we build the Kutools for Excel's Copy Cell Formatting utility, because Format Painter can only copy all formatting from one place in Excel. We can quickly apply these operations in Excel with Copy Cell Formatting.
Copy specific formatting from one cell and apply it to other cells
Click Kutools >> Format >> Copy Cell Formatting, see screenshots:
 |  |  |
Copy specific formatting from one cell and apply it to other cells
To copy and apply some specific formatting from one cell to other cells you selected, please do as follows:
1. Select a single cell (A1 for example) that you want to apply its formatting to other cells.
2. And then apply this utility by clicking Kutools > Format > Copy Cell Formatting.
3. In the Copy Cell Formatting dialog box, please specify the formatting attributes for other cells you want to apply, see screenshot:
4. Then click OK, and select the cells that you want to apply this formatting in the prompt box, see screenshot:
5. Then click OK button, the specific cell formatting from cell A1 has been applied to the selected cells at once, see screenshot:
Note:
This tool supports undo (Ctrl + Z).
Demo: Copy a cell formatting from one cell to other cells in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
