[0]
hello last time were talking about how
to freeze the first row but how about
[8]
we freeze the first row and the bottom line together so when we scroll down you can
[16]
see the first row still freezing and
also the bottom line not moving okay so
[25]
lets me show you how to do that let's
open a new one and from here lets me
[35]
make it larger so you can see it
clearly so the first thing you select
[42]
your table area, we can select for example multiple lines and go to insert
[54]
table when you select table you need to
make sure my table has headers was
[62]
checked ok check it, click ok now we have
columns here so in this case when you
[72]
scroll down you can see the column the
time it automatically goes up and
[81]
freezing there ok and to remove this
drop-down menu we go to design select
[92]
the table area first ok then select,
banded rows is the lines that has different color
[102]
we do't want that and also filter button
then we uncheck that sorry we need to
[112]
move back to the first line and now you
you can see there is no drop down arrow
[122]
ok, we can change the color, anyway let's change the name
[130]
actually let's go back to copy it
[139]
past, values, now we have this one, and these two columns we don't need . just select them
[150]
then right click delete them.
okay now they have all of them
[162]
now when we scroll down the first row
was freezing
[168]
how about bottom one so when they scroll
down to the bottom of the table we
[179]
select any row for example this one we
go back to view split now we go back to
[191]
the first table see when we move
this scroll down or up the bottom
[206]
line never move okay we can put it here
and then let's merge it go to
[215]
home click that merge it and you can
input any value for example you can see
[259]
and make it like this
[267]
okay no it's not moved so when they
scroll up or down the top row was
[276]
freezing
what is about while also freely hope you
[282]
enjoy this video and see you next time
