- [Instructor] 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 one and two
is darker than the other ones.
But more important, and I'll be using the mouse wheel here,
simply rolling it or 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."
We go back to Freeze Panes and Unfreeze the Panes.
The commands in this Windows group cannot fall
into the category of commands you can undo and redo.
But because they're so easy to work with,
considering what they do, we can certainly freeze
and unfreeze as necessary.
Now, there are many columns in this worksheet.
And 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?
Well, right now we've got to scroll leftward
so we can see column A.
So sometimes you will 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 one.
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 wanna 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,
I'll 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.
It automatically takes the place of the column letters
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 wanna 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.