How to freeze column or row headers in Excel

The Window > Freeze Pane feature can be used to keep the initial rows (or initial columns) of a spreadsheet static while the rest of the spreadsheet can be moved with the scroll bar or mouse wheel. Select the row or column immediately after the headings that you want to freeze.