Making first row in spreadsheet not scroll

[rogerlier]

I have created a database in an Excel sheet and when I scroll down, I
do not want the header info in row 1 to move. How do I do that?

 

[Kevin Badgery]

I have created a database in an Excel sheet and when I scroll down, I
do not want the header info in row 1 to move. How do I do that?

Select cell A2, then from the toolbar >Windows>Freeze Panes.

Basically, the Freeze Panes cmd will freeze any COLUMNS to the LEFT of the
selected cell and any ROWS ABOVE.

So by selecting A2, there are no columns to the left, only row 1 above.

To remove the freeze >Windows>Unfreeze Panes.