hello and welcome to our new video
in this video we are going to talk about
scale to fit
and cheat option
now what are these two things
this is related to page setup
which we have seen
what kind of page we need during print out
so this is also related to that
now where we will get to see this
or how it is used
while printing out
so let's see that
so first of all let's open excel
and here I have some data
here I have
70 students data
in which some marks are there
total and maximum
now what I have to do
in this
or the option which I talked about
like cheat option or scale to fit
where I get to see that
so that I will get to see
in page layout tab
so here this option is given
of scale to fit
and here sheet option is given
first let's see scale to fit
when I will print out
so I will show you
print out
so first of all
let's see preview
of this
in preview I am getting to know
that 70 students data is coming in two pages
first page is this
till 42 and second page is this
till 70
I want my data
to come in one page
then what I have to do
so there I have to do
scale to fit
here three options are given
basically one for width
one for height and one for scale
ok
so now what is width option doing
one is automatic
and after that
what is the meaning of 1 page, 2 page, 3 page
suppose
I can see
what is this
we know that
it divides the page
it tells us the dotted line
that where is your page 1
where is page 2
in one sheet 1
so if I do this thing here
that
these four things
subject data
with maximum
copy from here
copy from here and paste here
which option will work for me
now we
know one thing
that my dotted line
means
some data is coming in first page
and after this dotted line
like Hindi subject
Physics subject or maximum
where is this coming
in second page
so if I go to print
what I get to see
let's print
so see
here is maximum
and here is science
subject only
it didn't take Hindi subject
it didn't take physics subject
and one more column was maximum
it didn't take that
so I go to second page
everything is same in second page
go to third page
so this remaining data
remaining columns
I showed them in third and fourth page
this is your remaining columns
Hindi, Physics, Maximum
print this in third page
and after that
rest of the data is in fourth page
but we don't want like this
we want this
so that's why
all these things
so let's go back and see
now I want
these remaining columns
which was showing in third and fourth page
I want it to show in one page
so from here
I will select one page
now let's print
let's print
now see
now one thing happened
scale which was 100%
now I will show you
so you see
Hindi, Physics, Maximum
it shows in one page
and in second page
the remaining data
so let's go back
and here you see
scale is 77%
before it was 100%
so when we change
so that scale
changes like
if we try to print
two pages data in one page
so scale
can decrease
you have to remember this
so now what we have to do
our data was coming in two pages
like till 42
students data was coming in one page
remaining data was coming in second page
we want this to come in one page
then what we have to do
we will go to height
we will change height to one page
scale is 62%
before it was 75%
now it is decreased
so let's print
and see the preview
so it looks like this
your data will come in one page
but it is zoomed out
so it will not be useful for you
so here
suggestion is
when your data is more
like till 42
suppose 2-3 rows are more
in that case
you have to use one page
so that it will not be zoomed out
so that you can't see
like here
after printout
you can't see
let me show you
in which case you have to use
like in sheet 2
student data is
till 50
so what we have to do
let it come in one page
actually
I don't have to change width
because we know maximum
column will come in one page
so let's change it
in change case
let's change height
let's change height to one page
scale is not decreased much
it is 86%
before it was 62%
when data was more
so now
let's printout
now I can see the data
data is not zoomed out
if I printout
then I can see
what is my data
so we have understood
how to use scale to fit
after this
we have sheet option
in sheet option
we have two options
grid lines and headings
now what is grid lines
these lines
row and column lines
in normal case
if I go to printout
then I can see
rest of the area is white
where ever my data is
I can see those lines
if I go to grid lines
I want these grid lines
to be printed
it means
this is my first page
this dotted line
I have 4 columns
h, i, j
and inside these columns
these lines are grid
if I want these lines
then I will
printout
and now let's see
how it looks
it didn't show
let's see again
let's go
to printout
it should show
and
if we printout
the headings
let's printout
ok
it took the headings
let me show you
let me remove this
and
printout
now what is heading
it means
these columns
it will take these columns
and from here
it will take row numbers
so from here
let me printout
I have checked it
and now let's go to printout
see
it shows
1, 2, 3, 5, 6, 7, 8, 9
generally
we don't need these things
but
if you feel need
then you can use
these options
for headings and grid lines
let's see
again
it may be a technical issue
because of which it is not showing
or it can vary
I am using 2016
if you are using 2013
then you can show it inside
it should show in page setup
but it is not showing
so it is not a big issue
but we should understand
when we do it on grid line
then it should show in these lines
ok
so I think it is clear
how to use scale to fit and sheet options
ok
let's see sheet options
there are no other options
for which
we need
but this is enough
for this video
I hope you understood
if you have any doubt
then play this video again