Formatting Options  

Using the Apply Formatting Options tool to use and save your own format settings. Select a cell and press this button many times to see the different format settings you selected.

Open the Pick Up Formatting Options window
Select the formats that you want to copy (alignment, number, font, borders, patterns).
In the Pick Up Formatting Options window, press to copy your selected format types automatically.