
-
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.