MS Excel
The Paste Special command lets you copy and paste:

The resulting values of a formula instead of the actual formula
Cell comments
Multiply the selection by a copied value
Formatting options

ANSWER DOWNLOAD EXAMIANS APP

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

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
The Edit > Copy Format and Edit>Paste Format commands form the menu
The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

ANSWER DOWNLOAD EXAMIANS APP