Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.
To copy cell formatting in your worksheet:
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.