1.The Edit>Copy Format and Edit>Paste Format commands form the menu.
2.The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
3.There is no way to copy and apply formatting in Excel – You have to do it manually
4.The Format Painter button on the standard toolbar