Copy and apply formatting
Select the text, shape, cells, or picture that has the format you want to copy.
-
Select Format Painter
.
Single-click Format Painter
to apply the formatting once.
Double-click Format Painter
to apply the formatting more than once.
Select what you want to apply the formatting to.
Microsoft Excel | Copy and apply formatting (Video)