Convert Excel To Pdf Without Page Breaks

For example 20 120.

Convert excel to pdf without page breaks. Select all sheets that you want to convert to the pdf. Use either cmd or shift to select several sheets. As per the description you are converting a single excel page into a pdf but it results into 9 pdf pages as well as the fonts are bigger in the resultant pdf is that correct. Then save as pdf as usual and all of the data should fit on one oversized pdf sheet.

In page setup you could set the page size in inches to a custom size that is big enough for your whole sheet. The only way i could make a long scrolling single page pdf was to put the entire text of the pdf into an html page print the page to a new pdf using a page print extension then import the resulting long pdf into the program. Now try to save as pdf and this should cover larger area within the pdf file. It just compresses it to a a4 view making the data unreadable.

However when it comes to turning these files into pdf documents that can be read printed or distributed to others it s something that you should be conscious of. Convert excel to pdf online easily and free. Convert excel to pdf and set the page orientation as you prefer. We often don t think of excel spreadsheets as documents with borders pages and margins.

Also if you are using paper width as a setting check in the page layout ribbon in excel what page size margins orientation you ve got selected as this has an impact on the pdf output that is generated from excel. Pdf is a printing format so can t be set to an abstract unlimited page length. Under the tab page layout open page setup to setup header footer margin etc. 1 launch acrobat click edit preferences convert to pdf.

In the acrobat pdf maker dialog box select fit worksheet to a single page to ensure the full worksheet fits on the page. However converting an excel file to a pdf can be a bit tricky. Open excel click on the view tab select page break view drag the page breaks to the size you want displayed in the pdf format. Thanks for your suggestion.

If using acrobat to convert excel to pdf try changing the following setting and see if that works. When you have your excel file open in microsoft excel. We also discuss how to set page breaks in excel 2010.