Select the fit sheet on one page option. This happens because one or multiple sheets in your workbook have a different dpi setting for printing.
To fit your document to print on one page choose 1 pages.
How to fit excel sheet on one page pdf.
Go to the scale to fit group under the page layout tab.
Scale a worksheet to print in a different font size.
Click the file tab at the top left corner of the window.
If they arent each sheet will be created as a separate pdf document but you can also easily merge these afterwards.
To change the scale factor manually click the adjust to radio button and then type the value into the box.
Open your spreadsheet in excel 2013.
Then it resizes print area and there is only one page to print.
Click the print option in the column at the left side of the window.
In excel 2007 click the page layout tab then click the small arrow in the bottom right corner of the page setup group this also works for excel 2010 as an alternative to the instructions above in earlier versions of excel and for excel 2008 and 2011 for mac click file then page setup.
If you have multiple individual sheets within your excel workbook when you try to create a pdf and choose to print the entire workbook each sheet will be saved as a different pdf file.
Excel 2011 will only save all of your sheets as one pdf file if the headers and footers for each sheet are identical.
Under settings click custom scaling custom scaling options.
Click page layout.
So if you cant find an easy fix heres a way to print the excel sheet as one long continous single page pdf.
To fit the entire excel sheet on one page type 1 into the pages wide and tall boxes.
Shrink a worksheet to fit on one page.
Highlight the cells to convert to pdf page layout print area set print area page layout size more paper.
Ensure that the headers and footers on all of your sheets are the same optional.
This method is valid in microsoft excel 2007 later version.
Change both of width and height to 1 page.
Select fit to under scaling.
Lets presume for example that your normal page size is say a4 portrait which is 210mm wide x 297mmm high in excel.
Actually we can resize the print area and fit to one page by changing the scale to fit settings.
Select the page tab in the page setup dialog box.
This opens up the page setup dialog box.
Select the correct paper size from the paper size menu and click ok click the print button to print the spreadsheet.
In the worksheet click file print.
Click page and in the adjust to box choose a percentage by which you want to increase or decrease the font size.
Review your changes in print.
Click the no scaling button under the settings section.
Click the small dialog box launcher on the bottom right.
No comments:
Post a Comment