To scroll up and down a worksheet while always seeing title rows at the top or keep certain columns always visible on the left, use the Freeze Panes button on the View tab.
- As you start to scroll down a worksheet, using either mouse or possibly arrow keys, you've got a scroll bar on the right hand side, you can point to a box and scroll this way, what's missing as we move down the list? The top row. On this worksheet, called Freezing, in our workbook, 08 - Worksheet Views, we'd like to freeze the top row. And as long as it's visible, we can click anywhere in the worksheet, and go to the View tab in the ribbon. Freeze Panes, Freeze Top Row.
And you see the description, Keep the top row visible while scrolling through the rest of the worksheet. There's a subtle difference on the screen, the line separator between rows 1 and 2 is darker than the other ones. But more important, and I'll be using the mouse wheel here, simply rolling it, and moving down the screen, seeing these other rows, but always seeing that title on top. This has nothing to do with printing, but it certainly makes it easier to work with your data. Now, sometimes you say, "Well, I don't need that anymore." You go back to Freeze Panes, and Unfreeze the panes.
The commands in this Windows group cannot fall under the category of commands you can Undo and Redo. But because they're so easy to work with, considering what they do, you can certainly Freeze and Unfreeze as necessary. Now, there aren't many columns in this worksheet. But when you do have lots of columns, sometimes when you're scrolling left and right, I'm gonna grab that scroll bar in the lower right hand corner and slide it to the right, maybe we're looking at some of this data here, and we wanna remind ourselves, which person is this? Right now, we gotta scroll leftwards so we can see column A.
So sometimes you'll want to freeze the leftmost column. Make sure it's visible, click on any cell, Freeze Panes, Freeze First Column. Doesn't say left column, but that's what it means. Freeze First Column. Again, a subtle difference, the boundary between columns A and B is a slightly darker line. But now, using the scroll bar, or if we're using our arrow keys, as we scroll rightward, and leftward, we're always seeing column A. Now you can also together freeze the top row and the left column, or multiple rows, and multiple columns, when necessary.
But in order to approach that, we need to go back to Freeze Panes and Unfreeze the panes. Now, depending upon where we click, and I'll show you the command first, Freeze Panes, we're about to use the top choice, and as we read it, Keep rows and columns visible while the rest of the worksheet scrolls, based on current selection. That doesn't quite tell us everything we need to know. But here's the idea. If we use that feature, we are about to freeze all rows above the current active cell, and all columns to the left.
So let's imagine that we need to see that top row and the left column, we'll click in cell B2. If we wanna see columns A and B together, along with the top row, we'll click in cell C2. It's more likely we'll need that first version, so we'll click right here, and now, Freeze Panes, Freeze Panes, we can scroll right and left, and always see column A, we can scroll up and down, always see row 1. Again, this has nothing to do with printing, but it's a handy tool to be always clear as to which kind of data we're looking at, and which person we're devoted to.
Now, at different times here, you might want to consider changing data into a table. That's the stuff of a different course, but just a quick reminder here, if you don't have this feature in place, then go back to Freeze Panes, and Unfreeze. If you do convert this into a table, for example, you can do it by way of the Insert tab, Table, it gives you a distinct look, but here automatically the top row is frozen. That automatically takes the place of the column rows as you scroll up and down. So if you are using data that's been converted to a table, you don't need to worry about freezing that top row.
So freezing panes makes good sense, particularly when you want to see that top row, or the left column. And as I press Undo here, and undo the table aspect of this, we're back to a normal display, we're reminded of how valuable that is, as we work with list type data.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros