Question

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

Accepted Answer

The Format Painter button on the standard toolbar

Answer

The Edit > Copy Format and Edit > Paste Format commands form the menu

Answer

The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

Answer

There is no way to copy and apply formatting in Excel – You have to do it manually

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

Discusssion