Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Possible Duplicate:
Excel: Keep part of a spreadsheet up during navigation

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?

share|improve this question

marked as duplicate by slhck Oct 19 '12 at 16:08

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

3 Answers 3

up vote 6 down vote accepted

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.

share|improve this answer
    
Ah, that's what it's called. Thanks. There's a short explanation with screenshots here; in more recent versions of Excel, there's a Freeze Panes button under the View segment of the ribbon. –  Pops Jan 3 '11 at 23:35
    
And the Excel 2007 version of that tutorial is here. –  Pops Mar 31 '11 at 15:46

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: alt text

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

share|improve this answer
1  
This doesn't actually freeze the header cells; instead, it splits the window so you get two semi-independent views of it. Both functions can be useful, but for best results, don't confuse them. –  Martha Jan 4 '11 at 0:50
1  
@Martha -- Agreed, but I find having to line everything up and hunting for a menu much more tedious than just grabbing the handle and sliding it around. I pointed it out because it's a feature of Excel that most people don't know about. I gave him the option. –  bahamat Jan 4 '11 at 1:07

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.

screenshot of vertical bar near where the scrollbars meet

EDIT:
Looks like the bar can appear to the left of the horizontal scrollbar as well:

screenshot of vertical bar to the left of the horizontal scrollbar

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.