If you want to freeze a row of titles or categories so that you can keep them in sight as you enter data further down your spreadsheet, Microsoft Excel has a handy Freeze Panes function. To lock a pane, use your mouse to select the row below or the column to the right of where you want to freeze. On the Window menu, click Freeze Panes.
