Question: how to copy the same format in excel?
Answer: Select the cell with the formatting you want to copy.
On the Home tab, in the Clipboard group, click the Format Painter button. The pointer will change to a paint brush.
Move to the cell where you want to apply the formatting and click on it.