Copy cell formatting

-
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 the Answers community.