hello and welcome to a new video
in this video we will see
what is status bar
and in excel
what is the use of status bar
so let's open excel
and see
where is status bar present
so you can see
this green bar
you can see
do you remember
we zoom in and zoom out
excel workbook
zoom in and zoom out
feature
where is it present
in status bar
in bottom
you can see plus sign
if you
click it
your workbook
your sheet
will zoom in
let's zoom in more
to see
it
now see
from here
zoom in
zoom out
and
we have some data
so now
in starting video
we saw
so many columns
so many rows
when we go to print
what is the size of sheet
A4 size sheet
so now we have so many columns
and so many rows
so how to find
how many page
where it ends
and where it starts
and if we
print out
whole excel workbook
sheet
will it take all columns
all rows
it will not take all columns and all rows
so we will talk about this
you
zoom in and zoom out
where is zoom out
next to it
page break preview
so what is it
your workbook
in workbook
you can see this portion
in this portion
it will show
from where it starts
and where it ends
click on this option
click on preview
click here
it shows
in this portion
it means
after i
second page starts
it is a common thing
and rest of the
columns
and rest of the cells
are in grey
so page 1 is this
now we will do this in normal view
one thing you will get
page break preview
where you can see
where it starts
and where it ends
next to it
page layout
we will see
before that
convert it to normal view
now normal view
is
when you
open excel
that is normal view
but
now you will notice
one thing
dotted line
i will increase it
see here
dotted line
it was not here
when it came
when we
break page
and preview
now if we
see in rows
you will see
this is row
it means
from page 1
to
this
this section
is page 1
and below is page 2
let's write some data
let's write Rahul
and below
Imran
drag it
now
this page
is page 3
let's write something in 4th page
2,4
and select both
and drag it
and here
1,2,3
and
select all
and drag it
till here
now in page break view
you can see
all 4 pages
sorry
now in page break view
you can see
here is page 1
here is page 3
here is page 4
and this page is page 2
now we understand
in whole workbook
there are many columns
and many rows
but it doesn't mean
when we go to print
all columns will be printed
or all rows will be printed
what happens is
we can do it in page break view
and from page break view
we get an idea
what idea we get?
we get an idea that from where to where
your page exist
let's do it in normal view
ok
let's delete this data
ok
now
now we understand
in normal view
in status bar
in page break view
and in page layout
in page layout
zoom in and zoom out
and in left bottom
what we see
ready
in read mode
now
let's see in page layout
what we see in page layout
let's see
in this portion
in this page
in upper portion
you can see
add header
and in bottom
footer
what is the use of footer and header
you must have seen in your notebook
what is in notebook
you can put any heading
or
date
and
in footer
what we put in footer
we put page number
like here
page number 1
here page number 1
and in this
page number 2
and in header
you can put any heading
so this is the use of footer
and in layout
it shows header
and footer
so we can add footer and header
apart from this
when you open
notebook or printed book
you can see
some empty space
this is called margin
in which
if you want to make notes
you can write
extra information
apart from this
your table
or page content
will be from here to here
what you can do with this scale
you can reduce left margin
or right margin
like let's see
what we do
we reduce margin
so left margin
is increased
we have
reduced data
area
like we reduce this area
so by reducing area
what will happen
by reducing area
margin will increase
like we increase margin
sorry
we reduce margin
left margin
so data area will increase
like this we do here
what we have to do
here
we have to increase
data area
so margin will be
reduced
everything is clear
header
footer
scale
margin
everything is clear
after this
what we have to see
it is showing everything
in status bar
page 3 or 4
it is showing
let's do it in normal view
apart from this
it can show
in status bar
suppose
this is all data
what we have to do
as soon as I select data
count it
it shows
number
8 numbers
1,2,3,4,5,6
it shows
sum is 193
but I have not
put any formula
so how it shows
status bar
helps us
it shows
everything
it shows
average is 24
so how much benefit it gives
we don't have to find average and sum
someone asked
what is sum
we simply select it
and status bar tells us that
sum is 190
and average is 24
if we do both of them
then what will happen
sum is 266 and
count is 16
and average is
17
so it is clear that
how does status bar work
and how does it work
if I want to apply formula
then I can apply formula
then it will show me
average
and sum
so it is clear that
what all things we can see here
apart from this what else we can do
like if I select
this
then it shows me
count 9
suppose someone removed this
and wrote tax here
then will it count tax
or not
if it will count tax
then it should be 9
if it will not count tax
then it should be 8
so I select it
and I see
it counts 9
1,2,3,4,5,6,7,8,9
it means
it is counting this
let's see other things
if we select this
we don't have to write here
let's write here
aarti
let's write aarti
and select this
and let's see
it is showing
average is 10
1,2,3,4,5,6,7,8
but how it shows average is 10
average is 8
so what is it doing here
let's select it again
sorry it is showing average is 10
not 10
it will count and divide
it is showing count is 8
count 8 means
1,2,3,4,5,6,7,8
it means
it is counting tax
but
number which it will add
or average
it will add 3
7,8,10,12,13,15
there is nothing to explain
it can't do to aarti
because it is tax
we can't add tax and number
we can add number and number
and this thing
we have seen
in number formatting video
we have seen
we can add number from number
we can add date from date
we have seen we can reduce time from time
now
one last thing
in this status bar
if you
right click
here
you will see many options
this option is
customize option
you will see customize option everywhere
we have seen in short and filter
we have seen in find and select
we have seen in autosum
so customize option is given
if user doesn't like
already set things
so what it can do
it can add things
what it can add
cell mode
flash fill blank
cells
caps lock
what is caps lock
now it is off
let's see caps lock
I have turned on caps lock
after turning on caps lock
if I write something
it is showing
you can enter
you are in enter mode
if we write something
what is our next step
what we have to do in next step
we have to enter
it is showing
we have entered
now you will see what is caps lock
it is on
num lock
it is on
macro recording
it is on
note recording
it is on
selection mode
page number
page layout
page 3 of 4
page number
if we uncheck
it will not show page number
why it is showing average and count
because it is selected
after that it is numerical count
minimum and maximum
if we check maximum
it will show in status bar
if we select it
we have
max 193
what we can do
we can add things in status bar
so that
it is easy for us
if I don't add maximum
what option I have
I can go to auto sum
and use max function
then I can know
list available
what is maximum
it is clear
we can add minimum
add minimum
minimum is 5
it is clear
what we can do
we can add
it is clear
how status bar helps us
that's all in this video
see you in next video