When you have a long Microsoft Excel spreadsheet that contains a lot of data, you might end up scrolling down far enough that the cells you have designated as column headers move out of view, making it harder to distinguish what the data in each column represents. Excel offers an option to freeze these cells and keep them permanently in view.
Step
Launch Excel and open your spreadsheet.
Step
Select the "View" tab at the top of the Excel window.
Step
Click the "Freeze Panes" button. This will open a drop-down menu.
Video of the Day
Step
Click "Freeze Top Row."
