MS Excel
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Unfreeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
Freeze panes command on the window menu

ANSWER DOWNLOAD EXAMIANS APP

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

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

ANSWER DOWNLOAD EXAMIANS APP