Q. To copy formatting from one area in a worksheet and apply it to another area you would use

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 MS-Excel - You have to do it manually.
4. The Format Painter button on the standard toolbar