![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.
-
Choose a cell to copy.
-
Select an Excel Style.
-
Select Format Painter and drag to apply the Style.
Copy number formatting
-
Choose a cell to copy.
-
Select an Excel Style.
-
Select Format Painter and drag to apply the Style.