![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://cxcs.microsoft.net/static/public/surface-and-devices/neutral/4873755a-8b1e-497e-bc54-101d1e75d3e7/d07c07fd6aabfe12ed716e87301dc3a1a3a7b5b0.png)
-
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.