Q. To copy formatting from one area in a worksheet and apply it to another area you would use: (Solved)
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
- d. The Format Painter button on the standard toolbar