Use Format Painter to Copy Formats in Excel
The format painter is one of the most helpful Excel tools to help you save time. You can use it to take existing formatting and apply it to other cells.
To use it, start off by highlighting the cells that you want to copy formatting from. As you can see in the example, this can include multiple rows and Excel will alternate in how it applies it. Then, click on the Format Painter (paint brush) tool. Finally, click and drag over the cells that you want to apply the format to.