hello everyone in this video I will show you how to convert multiple excel sheets to pdf file
you have two scenarios, scenario number one: in case you have one excel sheet or one excel
workbook with multiple excel sheets. and the other scenario: in case you have two different files
and you want to convert sheets from the different files to a pdf so let's get started
In the first scenario, we have this excel file with different excel sheets so in case you want to
convert this to a PDF file what we do we go to file and then we go to export and
then we have create PDF icon click on this and before you click publish we click on options
we have several options we can control our pdf file the first one is for the active sheet for
example in January we have 10 pages so if you want all pages you click all and if you want specific
pages you can click this and specify the pages you want to print or the range you want but now
in today's video we need this part this section we click all again and then in this section what we
have click entire workbook it will convert all the sheets to PDF file let's try this click ok
and I will put a name I will choose a location desktop for example click publish
as you see it converted all the sheets but the page layout is not correct so
before we do that what we do we go to
page break preview and we adjust the page layout in order to be all on the same page
so after I corrected the page layout for all the pages I will go to file
and then go to export and click create
and then from here, we go to options and I will choose entire workbook and then click ok and then
I will write input okay in order to override my previous file and see how it looks like
after the conversion has been done you see all the sheets have been converted to
a pdf as you see on the screen sometimes you don't need all the sheets to be converted to pdf
for example, i want February, May and august for this click february 1st then hold
ctrl key on your keyboard then click the other sheets for example I will click may and keep
pressing on the control key then click august as you see i have selected three sheets again
we go to file and we go to export and click create and then click to and click options
this time we select active sheets active sheets mean what you have selected inside your workbook
and don't be confused by the selection selection is used for different things I will show you later
how to use it, for now, let's click ok and i will give it a name active shades and then
I'll choose a location and then click publish this will publish only these three sheets for me
and as you see we have February, May and august as expected and now let's see what that selection do
is only convert things selected area inside your sheet for example I will
select this after you have selected this you go to file and you go to export and click create
and go to options and we have a selection Click the selection and click ok then publish
as you see it converted only the selected area inside our excel sheet to pdf file
and nothing else this is scenario number one in case you have a different excel sheet for example
this one let me open another one sample two so now we have 2 excel sheets so let's say
we want january february and september as you see the september is from another excel sheet
for this, we have an easy tree what you do Click on the September and drag it to your
current excel sheet as you see the September came here and for example, we want January as well
January and September as you see January and September has been selected I will go
to file and then export and click create and from options you have to choose active sheets click ok
and then I'll write January and September and click publish or press enter on your keyboard
and as you see we have January and September has been converted to pdf and then you can close your
excel sheet and click don't save and on this you can click don't save again and this way we have
converted excel sheets to PDF files so easy I hope this video was useful to you in my next video
you