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.
Open up to the worksheet in the Microsoft Excel workbook.
Click the "View" tab.
Click the "Freeze Panes" icon. Select "Freeze Top Row" from the menu.
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.