hello and welcome to our new video
in this video we will learn
what is header
and what is footer
we have been reading books since childhood
we have seen in books
heading was written above
you can call that heading as header
and page numbers were written below
you can call that as footer
so in excel
how header and footer
are inserted in page
before this i will show you an example
for those who don't know
what is header and footer
so first of all
in this book you will see
some heading is written
chapter 1 what where how and when
so you can consider this
as header
and if i come below this page
then here it is written
2022
2023
we will call this as footer
similarly in second page
here there is no header
but if we go down
then you will see
footer is included
so what we have to see
in excel where is the option
of footer and header
in which tab
so we have understood
what is footer and header
now if we want to include
footer and header in our file
then how can we do that
i will close this
and open excel
so in excel
we have a table
in this table
you can't see any header
or footer
like in book
we can see footer
and in starting page
there is header
so here in this table
how can we include
footer and header
so first of all
we have to go to insert tab
insert tab is familiar
we have seen many things in insert tab
in insert tab
you will go here
in last
in text group
you will see header and footer
if you click on this
then you will see
in ribbon
tab is added
and we have seen this tab
in ribbon
when we worked with pictures
or when we worked with table
now when we are working with header
and footer
tab is added in ribbon
so what we have to do
we have to click on this tab
when we click on tab
then you will see many options
header, footer
page number
number of pages, current date
current time, file path
where i have saved this file
that is called file path
what is next
name of file
name of sheet
name of picture
many options
we will include these options
in this file
we will see how it works
now you will notice
when i click on header and footer
option
here you will see
header
if i click on this page
then you will see
option of add footer
and in every page
we can see this
this is second page
in second page also
we can see add header
and if we scroll down
we can see add footer
and if i scroll down
you can see
add header and add footer
so in every page
we can see
now we will see
what we can add in header and footer
for example
i have clicked on header
we have to go there
in header and footer
we can see these options
now if you click on header
then you will see
none
leave it as it is
then you have
page number 1
you have
page 1 of question mark
many times
we have 300 pages in our text book
so how will we know
page 1 of 300
page 2 of 300
page 3 of 300
page 4 of 300
so in this way we will know
total number of pages in text book
and currently
we are on which page
so we will know
page number of question mark
after this we have sheet 1
that on which sheet i am working
if i change the name of sheet
then here this name will also change
where we can add this thing
we can add in header
after this we have date
page number
and after this
we have f drive
in f drive the name of my file
is header and footer
.xlsx
so you can add this thing
what will be the benefit of this
suppose
you want to print out
in future
then you will know where this file is saved
or you print out
what will be printed in print out
that
this path is f drive
what is in f drive
here my file is stored in some folder
so what will be the benefit of this
you can easily
access this
after this
we have sheet 1 and page 1
and your
page number
or
printer
that thing will be written
header and footer will be written
after this many options are given
you can use this
for any option
suppose i want to put here
page 1
here
page 1
suppose
i want to copy this table
here
and the next option
page 1 of ?
how it works
let's add it
so simply you have to copy it
when you copy it
you have to
go here
and paste it
now
when you paste it
here automatically
page hash is shown
because we included page 1 only
but when we paste it
here automatically
page 2 is shown
so what we put in header
page number
now remove these two things
from here
and after this
what we do
go back to header
now see this option
page 1 of ?
now we know that we have two pages
so what should be written here
page 1 of 2
and what should be written on second page
page 2 of 2
so let's see
see what is written here
page 1 of 2
if we go here
so what is written here
page 2 of 2
if we go to page number 3
let's copy it and see
let's go down
and see
now see
what is written here
but if we paste it
so what is written here
page 2 of 3
page 3 of 3
changed
what happens with 7
things will change
so we understood
now what we have to do
this thing is formula
to include page
page 1 of ?
you will see same thing here
these are formulas
so don't bother
too much
you have to remember
what is page 1 of ?
and how can i include header
now suppose
i want to include path of my file
so what i will do
let's go to header and footer
tool option
after going here
you can add
sheet 1
but suppose i want to add
header and footer
and this is path of file
so what i will do
when i click on this
you will see
what is this
header is included
now if i want to print out
so will my header be included
in printout
so to see printout
what you have to do
what you have to do with your keyboard
ctrl plus p
key word
you have to click it
you will see preview
when you click ctrl plus p
now here
table
to printout
you will see
header
i think
it is clear
after this
i will remove this
after this
what options we have
go to table
and here
go to header and footer
this option
now we will see
what is left in header
page 1
you can add page number
and file name
you can add all these
page 1
and here
click anywhere page 1
and here
file name
here page 3
and here
header and footer
same thing
page 2
and header and footer
now let's go to footer section
now again
let's go to header and footer
here
in footer section also
same thing
here
page number
here
title
here
header
here
page 1
here
page 1
here
same thing
current time is 11.18
let's add it
current time
and this end time
is
formula
don't bother
to remember this
so you have to click anywhere
now see 11.18
now I will show you
something interesting
11.18
when I will go for printout
so in printout
11.18 should be there
but
11.19 will be there
if we go after 1 minute
now
see 11.18
if I print
11.19
so what will it do
if you put current time
in header or footer
so whenever
you take it to print
it will show that time
in that page
it will not show
that time
when you put it
suppose you put 10
but
for printout you are copying
12
so it will take 12
so remember this
similarly we have option of current date
suppose today you put date
18
and you are copying it
for printout
then what will happen
it will show 20
I will show you date
it is not possible
because we are recording
video on 15th Feb
so in 16th Feb
it is possible
so today
you can try this
I will remove
this
what I do in footer
in footer
I put current date
so here
this is date formula
so we click here
now see
you can click anywhere
so date formula will convert
current date
now here you can see
15th Feb 2023
now if you printout
you can see
11.20
11.19
11.20
15th Feb
2023
if you
see preview
date will change
to 16th Feb
very interesting feature
apart from this
what other features we have
to go to header and footer
to go to footer
go to insert tab
see here
page number is same
as given in header and footer
number of pages is same
as given in header and footer
we have seen current date
current time
path of file
name of file
you can put all these
after that go to footer
you have to go to footer
if you are on footer
then you have to go to header
by this you can shift
on header and footer
without using mouse
like end time
suppose you have written
end time in header
but you want to write in footer
so what you have to do
go to footer
where will this
come
see
this will come
in footer
footer means
you have added header
and footer
when you are on header
you can go to footer
when you are on footer
you can go to header
apart from this
different first page
if you have a note book
or text book
you have to show
other pages
will be similar
but first page will be different
so what i can do
different first page
here you can see
header of first page
ok
first page header is written
it will distinguish
see here
what is written here
or see below
this thing
will not come
because
my first page
is header
you can do like this
apart from this
don't worry
to print
this thing
will come
but this
and
other than this
what options we get
let's see in header and footer
again here
different odd and even pages
ok
what will happen
I didn't write page number here
if you write page number
odd and even pages
it will show them
scale with document and align with page margins
these are the things
I am telling you
this scale type is called ruler
what you can do with this ruler
with this ruler
like this
we have seen this before
you will say that this data
is in second page
yes it is possible
because you have done like this
send it back
so what happens
your sheet
size of your sheet
margins
ok
you have to reduce this margins
you can do this
with the help of ruler
this ruler
is given here also
horizontally
and vertically
ok
you can use both rulers
to reduce margins and increase margins
so I think it is clear
how to add header and footer
what is the use of header and footer
with header and footer
in notebook
suppose
you are preparing a document of 20-30 pages
so there is a suggestion
you can use this
because it will be convenient for you
so I think
header and footer is clear
so that's all for today's video
see you in next video
till then if you didn't understand anything
then you have to play the video again
till then have a nice day