Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.
-
Select the shape, text, picture, or worksheet cell with the formatting you want to copy.
-
Select Home > Clipboard > Format Painter.
-
Drag to select the shape, text, or worksheet cell and apply the Style.
Source: Microsoft