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

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

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you insert a row?

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
All of the listed here
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Select the row heading where you want to insert the new row and select Edit >Row from the menu

ANSWER DOWNLOAD EXAMIANS APP