How to Save Excel as PDF without Cutting Off (4 Suitable Ways)

Cutting off a page means the output will appear on several pages which makes the table less readable. To show all the methods, we take a dataset that includes sales details of some books. PDF Without Cutting off" width="700" height="408" />If we keep the default settings, the output will be divided into 2 different pages. We have six columns, but Excel will print only four columns on one page. PDF Without Cutting off" width="563" height="463" />The last two columns are shifted to the next page.

Method 1 – Adjusting the Page Size to Save Excel as a PDF without Cutting Off

• Go to the Page Layout in the ribbon, and in the Page Setup group, select Size.

Note:

You can easily change the page size from the Print Settings in the File tab.

• To save the Excel as PDF, go to the File tab and select Export.

PDF Without Cutting Off " width="637" height="325" />

• Change the File Name and click on Publish to convert your Excel file into PDF.

PDF Without Cutting Off " width="633" height="214" />

• We have a PDF file of your Excel without cutting off any columns or rows.

PDF Without Cutting Off " width="696" height="500" />

Method 2 – Save Excel as a PDF without Cutting Off by Changing the Orientation

By default, Excel will show your dataset in portrait mode. But, you can change the orientation according to your column and row numbers. For more columns, landscape can sometimes fit them on the same page.

Steps

• Go to the Page Layout tab in the ribbon and select Orientation from the Page Setup group.

PDF Without Cutting Off " width="391" height="133" />

• Select Landscape from the Orientation For our dataset, Landscape orientation gives a proper output.

PDF Without Cutting Off " width="289" height="194" />

Note:

You can alter your page orientation from the Print option in the File tab.

• Go to the File tab in the ribbon and select Export.

• A window will pop up where you can change your File name and click on Publish.

• That will save the Excel file as a PDF in the landscape orientation without any cut-off.

PDF Without Cutting Off " width="700" height="422" />

Method 3 – Using the Fit Sheet on One Page Option

Steps

• Go to the File tab in the ribbon and select the Print in the Settings options.
• Choose the sub-option called No Scaling.

PDF Without Cutting Off " width="491" height="646" />

• In the No Scaling option, select Fit Sheet on One Page. It will shrink our dataset and fit it on one page which also helps to maintain the continuity of our dataset.

• Go to the File tab in the ribbon and select Export.

• A window will pop up where you can change your File name and click on Publish.

• We’ll get the PDF format of our dataset without cutting off.

PDF Without Cutting Off " width="700" height="461" />

Method 4 – Scaling the Page to Save Excel as a PDF without Cutting Off

Steps

• Go to the Page Layout in the ribbon and, in the Scale to Fit group, alter the Width which is displayed as Automatic by default.

• Change the Width from Automatic to 1 page. This will adjust the whole dataset on one page.

• Go to the File tab in the ribbon and select Export.

• A new window will pop up where you can change your File name and click on Publish.

• This will convert the file to a PDF without cutting off.

Download the Practice Workbook