Excel: how to keep table header in place?

[hendra]

How do I keep the first row of Excel, the table header, to stay in place while dragging the scroll bar down?

[lbohn]

Window > Split

Drag the pane borders to set the static rows and/or columns.

After you set the static rows/columns, you can continue using Excel with the large pane borders or use Window > Freeze Panes to set the view and "hide" the borders.

--L.

[hendra]

Window > Split

Drag the pane borders to set the static rows and/or columns.

After you set the static rows/columns, you can continue using Excel with the large pane borders or use Window > Freeze Panes to set the view and "hide" the borders.

--L.

Thanks. It works!