If you have an Excel spreadsheet with many rows, you may want to keep the header row visible even when you scoll far down through the rows of the spreadsheet, so you know what the values in each column represent. This can easily be done, if you have headings for each column in the top row of the spreadsheet, or near the top row, by going to the top of the spreadsheet, so that the header row is the top row of the Excel window. Then click on the cell in column
A just below the
header row to make it the current cell. Then click on Window
and select Freeze Panes. Now, when you scroll down through the
spreadsheet, the header row will "float" at the top of the Excel
window, so that it is always visible and you don't have to scroll back
to the top again to remind yourself what data is found in each column.
If you have other rows above the column heading row you selected, those
will remain visible as well as everything above the row you were on
when you selected Freeze Panes.
If you later want to turn the display of the header row or rows when you scroll through the spreadhseet, click on Window and select Unfreeze Panes.
Note: this works in Microsoft Excel 2000 and later on Microsoft Windows systems and Microsoft Excel 2008 for Mac and should work on other versions of Excel as well.
