Join Dennis Taylor for an in-depth discussion in this video Freezing and unfreezing panes, part of Excel Essential Training (Office 365).
- [Instructor] When you work with large lists, as you start to scroll down the lists you might be using the scroll bar on the right hand side or maybe you're using the mouse wheel or the track pad. I'm using the mouse wheel here. What happens? Row one disappears. That's where the titles are. Well, maybe I don't know this data to well. I can figure out what some of the titles would be, but why not keep that row in place all the time by way of a feature called Freeze? Freeze Panes and it's found on the view tab in the ribbon. Freeze Panes, Freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet.
It's got three options. Many times we want to freeze the top row and when you apply this feature, just make sure it's visible. The active cell doesn't have to be there. Freeze top row. Subtle difference, separated between row one and two. It's a little darker. But as we start to use the mouse wheel to scroll down. You see what's happening. It's there all the time. It has nothing to do with printing. We can leave it here all the time if you wish or take it off at any time or reapply it. It has nothing to do with content. Let's say we remove it. Freeze panes.
Unfreeze panes. Now what if we had many, many columns here. We move left and right. We're losing track of which persons data we're seeing here. We might wanna see column A, the left most column. So as long as it's visible and the active cell could be anywhere, we could instead of freezing the top row, go to Freeze Panes. Freeze the First Column. Scrolling left and right. I use the scroll bar in the lower right hand corner. Scrolling to the right. We're always seeing Column A.
And you might be imagining could we see both? Could we always see row one and see column A. Yes we can. For the moment we've got column A frozen. Let's go back to Freeze Panes and unfreeze them. Now, as we go back to the button, before making a selection here, the first option Freeze Panes says, keep rows and columns visible, while the rest of the worksheet scrolls. Based on current selection, that doesn't quite tell you what to do. But here's how it works. If we apply that feature.
In other words, if the active cell is here or there or wherever, Excel will freeze every row above the active cell and to the left of it. So, if we need to see just column A and row one, we click in cell B2. If we wanted to see both columns A and B and row one, we'll click in cell C2. So the freeze will occur above and for the left of the active cell. We're at cell B2, Freeze Panes, freeze panes. We can scroll up and down.
We'll always see row one. And we can scroll left and right. We'll always see column A. And once again, this has no impact on printing or anything else. It doesn't change any data whatsoever. All these commands, too, by the way, fall into the category of commands that you cannot get to by way of the undo redo capability. And we don't really need that capability anyway. If we don't want the feature anymore, we'll simply unfreeze. And at a later time, apply it again. It's a relatively easy feature to use and it gives us the ability to easily move up and down and move left right within a worksheet and see those vital headings.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.