How can header cells in Excel be "pinned" or "frozen"?

If this is Excel 2007, you are looking for "Freeze Pane" under the View tab. If you want to know how to use it, open Excel help and look for freeze. The first result should be a detailed explanation on how to use the feature.