Copy cell formatting in your worksheet using copy and paste options, Format Painter, and dragging techniques.

  1. Select the shape, text, picture, or worksheet cell with the formatting you want to copy.

  2. Select Home > Clipboard > Format Painter.

  3. Drag to select the shape, text, or worksheet cell and apply the Style.



Source: Microsoft