Question: how to copy formatting in excel spreadsheet?
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.