Copy cell formatting with the Format Painter

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

Select the cell with the formatting you want to copy.

Cell with formatting
Select Home > Format Painter.

Format Painter
Drag to select the cell or range you want to apply the formatting to.

Cell Range
Release the mouse button and the formatting should now be applied.

Mouse Button