hi welcome to Excel tosh.com today we
are going to learn how to use free spins
wherein you can freeze your required
number of columns and rows and not just
the first row and first column so let's
say we have this data set of sales but
if you observe the first row has total
total of quantity and total of the total
sales and the data starts from the third
row what is most important about any
record is the order number and the order
date so the objective is whenever you
scroll down you want your headers to be
seen which are marked in red and
whenever if you scroll to the right side
you want the first two columns to always
be seen in the freeze panes option if
you use the second option which is free
stop row it will always freeze only the
first row and it will not freeze the
headers let P unfreeze it if I freeze
the first column it will only freeze the
a column and nothing else so for this
what we will have to use is a custom
option how to use this you place your
cursor let me highlight this only for
the sake of explanation so right now my
cursor is placed on cell c4 now when I
will apply the freeze panes which is the
first option under free spins what is
going to happen is all the rows above
this yellow mark and all the columns
before the yellow mark will get frozen
so when I do this above meaning three
rows and on the left meaning two columns
have got frozen if I scroll down you
will see that the three rows are frozen
if I scroll to the right you will see
that the two columns are frozen so keep
in mind wherever you keep your cursor on
the left of it and above it will get
frozen thank you for watching