Copy cell formatting
Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016-
Select the cell with the formatting you want to copy.
-
Select Home > Format Painter.
-
Drag to select the cell or range you want to apply the formatting to.
-
Release the mouse button and the formatting should now be applied.
Want more?
You can always ask an expert in the Excel Tech Community or get support in Communities.