WEBVTT
Kind: captions
Language: en

00:00:10.469 --> 00:00:15.849
When working with large spreadsheets in Excel,
the ability to freeze panes can be very helpful.

00:00:15.849 --> 00:00:17.850
It works just like it sounds.

00:00:17.850 --> 00:00:22.660
Certain columns or rows become frozen or fixed
in place, allowing you to scroll the length

00:00:22.660 --> 00:00:26.849
of your worksheet, and still see important
data like your header cells.

00:00:26.849 --> 00:00:31.689
To freeze any row, all you have to do is select
the one below the row you want to freeze.

00:00:31.689 --> 00:00:37.329
I want to freeze rows 1, 2, and 3, so they
stay at the top of the worksheet, even when

00:00:37.329 --> 00:00:38.970
I scroll down.

00:00:38.970 --> 00:00:42.149
That means the row I need to select is row
4.

00:00:42.149 --> 00:00:46.520
Now go to the Ribbon and select the View tab.

00:00:46.520 --> 00:00:49.180
Here we have the Freeze Panes command.

00:00:49.180 --> 00:00:53.690
Just click, and choose Freeze Panes from the
drop-down menu.

00:00:53.690 --> 00:00:58.250
A black line appears below the rows that are
frozen, sectioning off what moves and what

00:00:58.250 --> 00:01:03.940
stays in place when you scroll through the
data in your worksheet.

00:01:03.940 --> 00:01:05.710
Let's try freezing a column now.

00:01:05.710 --> 00:01:09.750
For example, when I scroll from left to right,
it would help to be able to see the names

00:01:09.750 --> 00:01:14.680
of all these expenses, which I have listed
back in column A. First I need to unfreeze

00:01:14.680 --> 00:01:20.620
my rows by going back to the Freeze Panes
command and selecting Unfreeze Panes.

00:01:20.620 --> 00:01:25.380
Now, remember there's a trick to the cells
you need to select when freezing.

00:01:25.380 --> 00:01:29.960
Instead of the column you want to freeze (in
my case, column A), you need to select the

00:01:29.960 --> 00:01:32.080
one to the right.

00:01:32.080 --> 00:01:36.970
Use the Freeze Panes command just like before,
and a black line appears to the right of the

00:01:36.970 --> 00:01:38.440
frozen area.

00:01:38.440 --> 00:01:43.690
Now we can scroll from month to month, and
the column of expenses stays in place.

00:01:43.690 --> 00:01:48.020
Freezing panes really goes a long way in making
your worksheet easier to navigate and easier

00:01:48.020 --> 00:02:12.330
to understand.