Question

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

Answer 1

Answer:

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

A. ...

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

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

The Format Painter button on the standard toolbar.