when working with large spreadsheets in
Excel the ability to freeze panes can be
very helpful it works just like it
sounds certain columns or rows become
frozen or fixed in place allowing you to
scroll the length of your worksheet and
still see important data like your
header cells to freeze any row all you
have to do is select the one below the
row you want to freeze
I want to freeze rows 1 2 & 3 so they
stay at the top of the worksheet even
when I scroll down that means the row I
need to select is row 4 now go to the
ribbon and select the View tab here we
have the freeze panes command just click
and choose freeze panes from the drop
down menu a black line appears below the
rows that are frozen sectioning off what
moves and what stays in place when you
scroll through the data in your
worksheet let's try freezing a column
now for example when I scroll from left
to right it would help to be able to see
the names of all these expenses which I
have listed back in column a first I
need to unfreeze my rows by going back
to the freeze panes command and
selecting unfreeze panes now remember
there's a trick to the cells you need to
select when freezing instead of the
column you want to freeze in my case
column a you need to select the one to
the right use the freeze panes command
just like before and a black line
appears to the right of the frozen area
now we can scroll from month to month
and the column of expenses stays in
place freezing panes really goes a long
way in making your worksheet easier to
navigate and easier to understand
like what you just saw rate it at a
comment subscribe to our chill the
freedom to learn what you want when you
want absolutely free
GCF learn free.org