How can i fix a row in an XL sheet (other rows can move up and down)?

Question

How can i fix a row in an XL sheet (other rows can move up and down)?

Answer 1

click Window then select Freeze Panes

Answer 2

select some cell below the row you want to freeze (or to the left of a column you want to freeze).  Then go to Windows > Freeze Pane.  To turn it off go back to Windows > UnFreeze Pane

so if you select cell B2 and freeze panes it will freeze row 1 and column A

you'll notice a line running up/down, right/left indicating that those are frozen areas.