How to Make the Top Row Scroll in Excel

Microsoft Excel spreadsheets can accommodate thousands of rows of data and a few hundred columns. Users commonly create headings at the top of those columns in the first row to describe the data in the rows that follow. Though the headings are commonly stated as letters and descriptors, different from the numeric data that shows in subsequent rows, that first line of cells across the top of the spreadsheet is still a plain old row and will scroll up and down with the rest. Fortunately, Microsoft includes a function in Excel that will automatically isolate this row and keep it stationary against other rows.

...
Microsoft Office 2007 Ultimate edition includes the Excel spreadsheet application.

Step

Open up to the worksheet in the Microsoft Excel workbook.

Step

Click the "View" tab.

Step

Click the "Freeze Panes" icon. Select "Freeze Top Row" from the menu.

Step

Click the "Windows Office" orb logo in the top left corner. Use the save options on the menu, if you want to make the top-row scroll permanent.