课程: Excel Essential Training (Microsoft 365)

Freezing and unfreezing panes

课程: Excel Essential Training (Microsoft 365)

开始一个月试用

Freezing and unfreezing panes

“

- [Instructor] If you work with large lists in Excel, a problem is that when you start to scroll down, perhaps using the mouse wheel or the arrow keys, at different times you might be forgetting which column is which. What does it stand for? What's the heading? We're missing row one. We can easily freeze row one. Make sure it's visible. You can click anywhere on the screen. But make sure row one is visible. And then on the View tab up in the ribbon, you'll see a choice called Freeze Panes. Click it. Freeze Top Row. Slight subtle change on the screen. The separator between row one and two is a black line as opposed to the other separators, which are likely to be gray lines if you're showing grid lines. As I start to scroll now, look what happens. Row one stays in place, and that's really handy. You can leave it there indefinitely. It has nothing to do with printing. If you save the file, open it, this feature will still be in effect. Has no impact whatsoever on content. Now, there's another possibility here though. I'm going to scroll to the right because I'm looking at some of the compensation numbers out here and I'm saying, which person is this about? And I have to scroll leftward to remind myself which employee I'm concerned with. So there could be times when you're more interested in freezing the first column. So let's go back to Freeze Panes and unfreeze the current frozen pane. And then, making sure the left-most column is visible, freeze the first column. There too, subtle difference between the column separator there and the other ones. Now as I scroll right, we always see column A. We always know which person, which employee we're concerned with here. And already you might be thinking, well, could we freeze the top row as well? Because now when we scroll up and down, we're forgetting what each column is about, let's say. We can do both, but we first have to unfreeze the panes, and then making sure that row one and column A are both visible, we'll click on cell B2. And now, as we Freeze Panes, the description, keep rows and columns visible while the rest of the worksheet scrolls based on current selection. What we are about to do is freeze all rows above the active cell and to the left of the active cell. Freeze Panes. And now we can scroll up and down and always see row one. And no matter where we are in this list, we can scroll left and right, and still see column A. Again, has no impact on content here. It has nothing to do with printing, and it's a way we cannot duplicate with paper, but it certainly is handy as we work with lists here. And as it is with certain features in Excel, you cannot undo these, but you can certainly go back to the View tab and unfreeze or freeze as necessary. So it doesn't fall into the category of commands you can undo. The next worksheet over has the same data, but it's been converted to a table. Now, you might not have worked with that feature just yet. Its main difference, at least initially for most people, is this look of banded rows and the automatic built-in fact that when you work with a table, as you scroll using the mouse wheel, you automatically see that the titles are there all the time. They take the place of the column letters. So there's no reason using this feature to freeze the top row, but you might want to freeze the left-most column. So in a table, you can certainly go to Freeze Panes, and as long as that first column is visible, Freeze First Column. We can now scroll left and right. And because it is a table, when we scroll up and down, we can always see those column headings. There are rare times when you might want to freeze multiple columns or multiple rows. We don't have the need here, but if for some reason the building site manager's looking at this list and he or she always wants to see columns A and B, then simply unfreeze the panes. This time click on cell C2. Come back, Freeze Panes. Now we can scroll left and right and always see those two columns up and down and always see that top row. So it's a handy feature, easy to get to. Freeze Panes. Found on the View tab in the ribbon.

内容