Join Dennis Taylor for an in-depth discussion in this video Freezing and unfreezing panes, part of Excel 2016 Essential Training.
- View Offline
- Like many lists in Excel, this list that we're seeing here is on a worksheet called Freezing in the Workbook 08 Worksheet Views, if we start to scroll downward using either arrow keys or the mouse, we lose sight of the top row. Titles are often in a single row up top, they can be in multiple rows in some cases, but the idea is as we move up and down we'd like to see row one all the time in this particular worksheet. Make sure it's visible, go to the Freeze Panes option, it's on the View tab and the ribbon.
Freeze Panes, now we've got a choice called Freeze Top Row. The active cell doesn't have to be in the top row right now, but it has to be visible, the row that you'd like to freeze. Freeze Top Row. And now as we start to scroll downward, using either arrow keys or mouse wheel, or the scroll bar on the right hand side, we always see row one. This has no implications what-so-ever about printing, it's not related to that at all. It's just a visual change on the worksheet. If at a later time or if for a certain time you don't need to use this or don't want to have it visible, go back to Freeze Panes, and Unfreeze Panes.
Now, you can also freeze the leftmost column. Make sure the column that you want to freeze is visible. The idea here might be as we scroll rightward, using either arrow keys or the scroll bar along the lower right portion of the screen, we're losing sight of what's in column A. So maybe we're looking at these Compensation amounts out here. Who is this person right here? Well, we have to scroll leftward to see who that is. So we might like to see column A all the time. Make sure it's visible, active cell can be anywhere, go back to Freeze Panes, and this time we're going to Freeze the First Column.
And now as we scroll rightward, we always see column A. And as we scroll up and down, we're not seeing row one all the time now. That might be useful, but for the moment, we're seeing column A all the time, no matter how far we scroll left and right, column A is always visible. Now there could be times when you might want to see more than one column on the left-hand-side. In that case, let's go back to Freeze Panes, and Unfreeze the Panes. What if we'd like to see columns A, B, and C all the time, no matter what? We want to position the active cell in column D right here.
And because we want to freeze more than one, we want to go to the top row here, in other words, D-1, then Freeze Panes, and choose Freeze Panes, not First Column. And the discription, "Keep rows and columns visible "while the rest of the worksheet scrolls, "based on current selection." That doesn't really tell us how to do it, but positioning the active cell, however, this is right now, means we're going to freeze everything to the left of this. Now as we scroll rightward, columns A, B, and C are always visible.
You can see what's happening there. If we no longer want this feature, or if we want to set up another kind of freeze, again we go back to the Freeze Panes, and Unfreeze the Panes. Now, what if we'd like to have both features that we've seen already together. In other words, we'd like to scroll up and down and always see row one, and maybe scroll left and right and always see, for example, columns A and B. Let's position the active cell at C-2. Be sure to have visible the row that we want to freeze and the columns that we want to freeze.
So what we're about to say, although we won't see this in the menu, we want to freeze everything to the left of, and above, the active cell. So in this case we go to cell C-2. Freeze Panes, Freeze Panes once again, based on current selection, although it doesn't quite tell us what that means, make the choice. Now as we scroll up and down, we always see row one. As we scroll left and right, we always see columns A and B. And that too, of course, has no implications regarding printing.
But it's a great visual tool for someone who has to look at this data often, needs to scroll up and down, look at this, look at that. We always are sure which category we're looking at, in other words, which field name we see in the column headings. And we always know which person we're dealing with, also the building. A lot of it's not that important, but still, you can make your choices here as to what it is you want to freeze. And if at any time, you no longer want the freezing effect, you can come back and unfreeze. It's important to note also, that most of the commands in the View tab, including this one, cannot fall under the category of something you undo or redo.
If you no longer need the feature, you'll turn it off, but you can't undo to turn it back on again. Of course, you can apply the feature. So let's just unfreeze the panes. So at a later time if we want to freeze again, or even now, if we want to freeze, we can't go through the undo process. But it's pretty easy to set up once you do this a few times. So freezing panes makes good sense, because we want to see our titles often, and it's not uncommon to also want to freeze a column as we saw in the example here.
- Working with the Excel interface
- 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