In this section, we're going to discuss how you can lock rows and columns to be able to efficiently view your data. As you scroll through the spreadsheet and you can scroll either up or down or left or right. This enables a portion of the screen to remain frozen or visible at all times. Go from freezing panes to complete Excel mastery with our hands-on Excel classes & bootcamp in NYC or live online.

Freeze Panes

So let's start by going over to The View tab, because what you will be doing is changing the view of your spreadsheet. Now, currently the sheet doesn't have any rows or columns frozen. If I scroll down, I will now no longer see the freeze panes header. I might like to see that header at the top of the worksheet.

Freezing Top Row

When I scroll down, I would not like it to disappear and move because maybe I like to see the title at the top. So on the View tab, I'll go over to freeze paints and there is a very easy option to choose. It's freeze top row and this will do what it says. It will freeze the top row. And the top row that's currently visible is a row one so with one click. Now when I scroll down, freeze panes always stays at the top. Now I'm going to go back and unfreeze pane so I can choose a different option. I may want to freeze column A. So there's also an easy to select preset option. It's called Freeze First Column. This will keep the first column visible while scrolling through the rest of the worksheet. One click.

There's a little dividing line between A and B. This is useful in case I want to compare information column A with information column C. I may have I.D. numbers in column A and I want to see what the value is in column Z. Column Z is wasn't currently visible, but as I'm moving across, I'm slowly bringing column A to column C, literally a tizzy. And now I can compare the two columns. Now I'm going to go back and unfreeze paints and remove that everything goes back to the way it was.

Freezing Other Rows

Now, someone might say, well, that's pretty convenient if you want to freeze the top row or the first column, what if I want to freeze row eleven, that's where my headers are. So how do I freeze row eleven? It's not the top row. If I want to use freeze paints, my advice to you would be to select row twelve. If you want to freeze row eleven. Select row twelve.

You're gonna select the row underneath the row that you want to freeze. Then you'll go and you'll simply choose freeze paints. When you do that, you scroll down. Row eleven is frozen, and now you'll always be able to see your headers, whether or not you're at the bottom or at the top of your data. Now I would like to do something else. Someone says I have information in A, B, C and D that I would like to remain the same and I would like to scroll and take a look at all the other columns. So if you want to freeze A through D, then the column you're going to select is going to be column E. So let me unfreeze panes first.

I'm going to click on column E, then I'll go and choose freeze panes from the freeze panes dropdown. Now if I move over to the right a through these frozen and I'm able to navigate to all the additional columns over to the right while keeping the first four frozen, someone says, I think you've solved all the situations where I might want to freeze panes.

Freezing Rows & Columns

There's just one situation I think you haven't accounted for. What if I would like to freeze both columns A through D and row eleven? I want to be able to scroll up and have row eleven stay the same and move over to the right and have columns A through D stay the same. So for this what you'll do is you'll select the cell that is both underneath row eleven and to the right of column D. That cell is E twelve.

Then you'll go to freeze panes, you'll select freeze panes and now you'll see these crosshairs. If I scroll down row eleven this frozen. And if I go to the right columns, A through D are locked. So this gives you the best of both worlds.

Finally, I go and unfreeze pains and everything is back to normal. So that's how you can freeze pains within your document.