How do you lock cells in Excel?

MKSheppard · Post by **MKSheppard** » 2006-11-21 11:15pm

E.g. I have a column or row that I always want to display (like the name row) no matter how far I scroll down or left/right.

What's the technical term for this?

The Silence and I · Post by **The Silence and I** » 2006-11-22 02:04am

I have found this site very useful in the past:

Link

In fact, I think the first question in the list might be right up your alley.

SeeingRed · Post by **SeeingRed** » 2006-11-22 04:03am

I think you can do this with split viewing panes. Just above the vertical scrollbar, and just to the right of the horizontal scrollbar, you should see two little widgets that you can click and drag on. For example, for your name row, you'd use the horizontal pane splitter (the one just above the vertical scrollbar) such that the top pane included the first row with the names, and then the bottom pane would let you view the rest of the spreadsheet.

Let me know if you want screenshots.

Chardok · Post by **Chardok** » 2006-11-22 09:08am

just click the cell or line underneath the one you want to always see, then
select the window drop down-->Freeze panes

YOU WIN!

MKSheppard · Post by **MKSheppard** » 2006-11-22 02:16pm

you sir are a true excel god