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

How can you "pin" or "freeze" cells in the top row and/or leftmost column of an MS Excel sheet, so that they always remain visible regardless of scrolling?

Solution 1:

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.

Solution 2:

Another way to do this, is there's a bar in the upper right corner that you can drag down for a horizontal split. I don't have a copy of Excel so I can't show you the effect, but here's the little bar:

There's also a little bar on the bottom of the screen that you can drag for a vertical split.

Solution 3:

Here's mate for bahamat's answer: there's a corresponding vertical bar at the bottom right corner of the screen that works the same way for isolating columns.

A bar can also appear to the left of the horizontal scrollbar as well, but this one doesn't do splitting. Instead, it is used for resizing the horizontal scrollbar: