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