hello and welcome to a new video
in this video we are going to learn
about page setup
now what does page setup do
to know that
we have to open excel
so lets open excel
after opening excel i can see here
that i have some data
if i go to print this data
then how this data
will be visible on that printout page
page setup is about that
so let me print this
to print this what you have to do
press ctrl plus p
then it will show you a preview
like this it showed me a preview
that if you printout this
then you will get
your data like this on the page
ok, so lets back this
i will come back to this
but before that let me tell you
where do we get
page setup option
so lets go to page layout tab
here we get page setup
now what is page setup
its a group
in previous classes
in page setup we get some options
like margins
orientation, size
print area, breaks, background
print title
now what are these options
we are going to see
one by one
so what we have to do
what is margin
when i take you to print
there is another way to print
here you can see
this customized quick access
toolbar
if you click on it
you can see an option
print preview and print
you have to check it
it will show you an option
print preview and print
if you click on it
it will show you
you can use shortcut
or directly use that button
now lets go to margins
what is margins
when i click on margin
it shows me
normal, wide, narrow
when we come from normal
to narrow
margin reduces
lets talk about margin
i will take you to print
again
i will click here directly
you can see some
area in side
some area in left
some area in right
some area in left
some area in right
some area in top
some area in left
some area in right
some area in bottom
this area is called margin
now with this margin
we can increase or decrease
in previous video
when we
took a page
we can see
margins in left
and right
in header and footer video
now
what is given here
options in margin
what is in normal
from top
1.91 cm
top margin
1.91 cm
bottom margin
1.78 cm
1.78 cm in right
if i talk about header
header and footer
will be included in margin
yes
if you
do not take header and footer
in margin
better
take header and footer
header and footer
top margin
will be
1.78 cm
in wide
top margin
2.54 cm
bottom margin
2.54 cm
left and right
header and footer
narrow margin
margin
1.91 cm
we go to margins again and we select this white one
we select white one and now we go
so you will see that the margin which we were doing in
narrow was very less
but here is it less?
no
here and here see
it is possible that here you can see margin more and here
you can see margin less
but what is happening in white case?
in white case margin is more than narrow
ok
let's take it back
apart from this
what is here?
you can see normal
if I click on normal and let's see print preview again
see
how does it take normal?
it takes by default
ok
we saw this when we broke the page
we saw that in worksheet when we take pages to print
you can see a dotted line
I will show you that dotted line again
from that dotted line we know that your page 1 ends here
page 2 ends here
page 3 ends here
all these things
now in margin we get the option of customization
like custom margin
if we go to custom margin
it is very interesting
here it has given us many options
top option, bottom option
header, footer, left, right
it has given us all these options
and if we want to set
manually set
like what I want to do
I do top from here
let's do 1
from here
ok
1.4
or let's write it directly
1
ok
I took margin from top
I took 1
so it will show you with 7
like from bottom
I take margin from bottom
I take margin of 1
and from left side
I take margin of 2
and from right side
I take margin of 2
so now see
when I clicked on right
it is showing me with 7
this black highlighted line
now see
if I do 5
so see carefully
will this line change or not
ok
from 5
what will happen from 5
now when we will see print preview
then you will know
see it was here
and from here to here
the area is on 5
like if I make it equal
2k
so what will happen here
in left side
how much margin will be left
that much will be left in right side
ok
after this is my header and footer
header is this
and footer is this
ok
I made header 1.3
and footer also 1.3
ok
and what I do
I click ok
here horizontally and vertically
option is also given
if I click ok
and now I click print preview
so you will see
from top it is less
from bottom you will not see
because here it is same
ok
left side
now you will say left and right
is equal
then why margin of right is more
margin of right is more because
data of table
is
columns
are less
that's why margin of right is more
like if I want to center it
let's see
where we have to go again
now it shows
custom setting
when it shows custom setting
when you customize it
like it shows
changes we made
from top 1 cm
from bottom 1 cm
from left 2 cm
from right 2 cm
from header 1.3 cm
from footer 1.3 cm
let's go back to custom margin
and from here
whatever data I have
whatever data I can see
it will come horizontally and vertically
horizontally we know
how it is done
vertically
so I do it horizontally
so you will see
movement
I will show you again
and if we do it vertically
it will come in center of page
let's do it vertically
you can see movement
let's ok it
and now let's go to print preview
now see
from here you will get equal
from top and bottom
if we
remove one
let's leave horizontal
and remove vertical
then we can see changes
let's go to margins again
and go to custom margins
and remove vertical
ok
let's go to print preview
from here we get equal
and from top and bottom
you can't see because of white spaces
but it's equal
horizontally
it will come in the center
and vertically it will come in the middle
so
this is our job of margins
when we go to print out
or to print out data on a page
then how
that data should be visible on that page
so margin we can do more or less
according to our needs
so margin option
helps us
this is a very useful feature
in excel
after that next option
which we get to see is orientation
now what is orientation
in camera many times you see
in landscape mode
we click the photo
like I show you how landscape is
just a second
when we take a photo in this way
then we can say
how is it, it is landscape
it is landscape mode
so if we want to print our data
on a page then we can do that
like if we go to orientation option
then we can see
portrait and landscape
like we click on portrait
and here you can see
so in portrait you can see
the same data
like in A4 size sheet
normally it is visible but in landscape
it will change, how it will change in landscape
we will see
in portrait what happens is
it is length wise
you can see the data in length
if I talk about
landscape
I said it wrong
in portrait you can see
length wise
but when I talk about landscape
you can see like this
you can see wide page
so let's see
so I change
its orientation
now I change to landscape
when I click on landscape
let's see
how was the page
it was in length
but now it is in width
so if I want to
print my data like this
then I can change its orientation
apart from this
the third option
is size option
now what is the use of size option
paper size
like A4 size
like we see here
we have available
legal size
A3 size
A4 size
so A3 size, A4 size
and legal size
are popular in market and easily available
so
from here you can
decide the size of the page
that what kind of page
you want to show
or print
like I do legal
select
and click on print preview
so you will see
that legal size
is too much
but if I change
to A4 size
then what will happen
like we can change from here
if I change to A3
then you will see
like this
if I change to A4
so what is in A4
you can see
data in A4
and A3
here what is the difference
centimeters
like in A3 you can see
29.7 cm x 42 cm
but in A4
21 cm x 29.7 cm
so here only the page size
changes
so from here
I can change
the page size
so from here
I can change the page size
so you can
change the page size
from here
you can set
and then
you will see the same data
other than this
I have options
print area
I have one option
so what I am saying
in print area
that now I will print this data
so this
will show on the page
but if I want
like I have 2 or 3 tables
like here
let's copy it again
I copied this table
and I paste it below
now if we see the print preview
you can see
both the tables
I can see both the tables
in the print preview
if I want
not 2 tables
but only one table
or
some row of the first table
then what will happen
then how will we do
so the option we use
is the print area option
now how to use it
like I click here
like you want
the tables to be printed
so I click here
and then
I click on print area
let's select it
I selected it
I clicked on set print area
so whatever I selected
what happened
it got selected
now if I go to print preview
then I can see the same table
but if I
go to the second table
now where is the second table
the second table
is available
it is on the page
but we can't see it
when we go to print
or let's do this
I want to print
some rows of my table
I want to print some rows of my table
I don't want to print the whole table
then also we can do this
I want to print
4 rows of my table
so I selected it
and I clicked on
set print area
and I clicked on set print area
now if I click on
print preview
I can see the same table
while printing
so this is a very useful option
if I want to remove it
then I click on
clear print area
then I click on
clear print area
then I can see
both the tables
so this is a very useful option
if you want to print
only one row on your page
then also you can do this
you can print only one table
then also you can do this
so now
let's go to
next option
next option is break option
what is this break option
insert page break
remove page break
reset all page break
page break
basically
when I go to print
then some of my data
will come on first page
rest of the data will come on second page
so this is useful
if I want
first table to come on first page
and second table to come on second page
then what I will do
there is a gap in row no.12
I click with mouse
and go to break option
insert page break
now if I go here
and see print preview
what happened here
what I saw on first page
I saw my table on first page
now here
things are divided in two pages
if we go to second page
we can see this
page 1
page 2
let's change its color
so that more things are clear
I select this
and from here I go to home
and change its color
and style
now I think more things are clear
let's select this
now I again
go to option
and see print preview
what I see on first page
this is what I see
when I go to second page
now it is clearly visible
what I am doing
let's go back
now we can do this
I have seen this
if I want
two tables
first table to come on first page
and second table to come on second page
if I want
four rows of starting
to come on one page
and second table to come on second page
is it possible
if I want data on top of this
what I can do
I go to page layout and break
I put a break here
after putting a break here
let's see
you will see
where I put a break in fifth row
above that
data is visible
and remaining data
is visible on second page
let's see
second page
remaining data is visible on second page
let's go to third page
table is visible
I think it is clear
if you want to remove this
what you can do
remove page break
if I have put two to three breaks
in a page
then remove will be one by one
but if I reset all
like reset all page breaks
then all page breaks
that I have put
will be removed
let's see next option
of background
click on background option
here it shows three options
from a file
in our system
some things are already available
some background is available
so we can pick it from here
this is microsoft
search engine bing
if i want to pick an image
and put it in background
so i can do one drive
like google drive
so i pick an online picture
like from here
nature
let's pick some pictures of nature
so what will happen
it will show you many pictures of nature
like i select
from here this picture
and insert it
try again
ok this picture is not downloading
let's download some more
like we need animal
we took out animal
and we tried to insert it
will it be inserted
yes it will be
so now
the background of table
this data
in this we can see
this
once it is downloaded
then i will show you
so here question will come
when it will be downloaded
and we can see
in background we can see
what
we have to convert
this file
we convert it in jpeg
file ok
let's do it again
ok
i go to background
and go to background
we don't pick from background
we pick from from a file
because internet connection is not good
so file is not downloading
let's go to download
if i have any picture
so let's see
let's pick
this picture
and insert it
so
what is the picture
no
some issue is coming
let's try again
picture is coming but
picture is greyish
let's try again
let's pick some other picture
let's see
let's pick
this one
let's insert
see
in this way you can see
picture in background
so now
question is
when i will print it
then also this background will come
answer is no
let's print it
when we
print it
this is for us
if we want to see something in background
while working
then it will show you in background
but not while printing
so if we want to remove it
then delete background
then last option is
print titles
let's see how it works
let's see
i go to print titles
it is showing
rows to repeat at top
let me show you
this
first
delete this
table
delete
sometimes
we have too much data
like here
let's increase it
delete
this
delete entire
row
delete
let me
decrease it
i decrease it
to 70
and
delete titles
repeat
we already know
how to do it
and
delete
entire data
let's see
let's repeat it
no problem
let's repeat it
to bottom
here we wrote this data
so this is data as it is
now if we want to print it
then it will not come in one page
because we have too much data
let's see
let's print it
so we see
but
in second page
we don't know
what are the titles
here is serial number
here is name
how to know
this is math or sociology
so something like this
on second page
title should be written
so this option is useful
let's go to back
let's go to print titles
and we
said
what do we want in top
we selected this
we said
we want this
we did ok
now if we go to print
you will see
it is visible here
it is visible on second page
now we will know
while printing
our data is science
or sociology
so this option is useful
I think you understood
how page layout works
in page layout
this is page setup option
we saw margins
orientation
size, print area, breaks
background
I hope you understood
this
if you have any doubt
you can watch this video again
I will meet you in next video