Many times when working with a large spread sheet you need to be able to view column headings at any point in your document. You can do this by freezing the panes. First go to the View tab, and in the Window group you will click Freeze Panes. From here you can Freeze you panes based on the cells you have highlighted, the first row, or first column. To unfreeze your panes simply follow these same steps, except when you click Freeze panes this time you will see an Unfreeze Panes option.
You are here: / / Freeze Panes in Excel 2010