You okay so in the short video we will see how to convert an excel file which is open in Excel 2010 to a PDF file so I have a sample excel file with me and I would like to convert this excel file into a PDF file with the Excel 2010 it is quite a simple job you just need to go to file save as and select dot PDF under save as type you need to select not PDF and hit Save button so you can see a PDF file is been created the problem with this PDF file is as you can see in the conversion process it has got broken into two so here while we have column tell greater than 6 p.m. and the PDF we have only columns till 2:00 to 4:00 p.m. and there are a rest two columns have gone into the second page whereas V on that all columns should should appear in a single page so here is what we need to do we need to set the page break such that this page break comes after greater than 6 p.m. column right now the page break is in between 2:00 to 4:00 p.m. and 4:00 to 6:00 p.m. as you can see this dotted line that are the dotted two vertical line we want this dotted vertical line to be after greater than 6 p.m. so here's what you can do you first need to go to file go to options advanced and make sure that enable file handle and cell drag and drop check box is affected once this is selected go to view and hit page break preview you will get a dialog box saying welcome to page break preview you can adjust where the page breaks are by clicking and running them with your mouse hit the ok button and now here you can see the blue dotted line so with the help of this blue dotted line and these double arrows you can adjust the page break view so we have adjusted the page break view now let us first go to the normal tab home will now hit file save as and convert it into a PDF file and here you can see the whole table is now in one single page you.