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

Microsoft Excel is a type of software where if you alter any cell, it will change the overall dataset. It is really painful in some cases. To remove this complexity, you can convert an Excel file or save your Excel file as a PDF. This article will cover all possible methods to save Excel as PDF without cutting off. I hope you enjoy the entire article and acquire some valuable knowledge about Excel.

How to Save Excel as PDF without Cutting Off: 4 Easy Methods

Here, we cover the four most useful methods to save Excel as PDF without cutting it off. All the methods provide a solution to save Excel files without cutting them off. Here, cutting off any page means the output will appear on several pages which gives the reader a nightmare. To show all the methods, we take a dataset that includes selling details of some books.

Here, if we keep the default settings, the output will be divided into 2 different pages. It eventually reduces the continuity of the dataset. Overall we have six columns but it provides four columns on one page.

The last two columns are shifted to the next page.

1. Adjusting Page Size to Save Excel as PDF without Cutting Off

Firstly, to save Excel as PDF without cutting off any columns, we can alter the page size to accommodate all the columns on one page. This method gives the reader the much-needed continuity of the dataset.

Steps

• To alter page size, go to the Page Layout in the ribbon, and in the Page Setup group, select Size.

• From the Size option, select A3.

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

• In the Export option, click on Create PDF/XPS.

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

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

Read More: How to Convert Excel to PDF with All Columns

2. Save Excel as PDF without Cutting Off by Changing Orientation

Our second method is based on altering the page orientation to save Excel as PDF without cutting off. Page orientation can be either in landscape mood or portrait mode. By default, Excel will show your dataset as a portrait mood. But, you can change the orientation according to your column and row numbers. For, higher column numbers, use landscape mood, and for higher row numbers, use portrait mood.

Steps

• To change page orientation, go to the Page Layout tab in the ribbon and select Orientation from the Page Setup group.

• Now, select Landscape from the Orientation For our dataset, Landscape orientation gives a proper output that’s why we choose it but you take a preview and then select which one is good for you.

• Now, go to the File tab in the ribbon and select Export.

• In the Export option, click on Create PDF/XPS.

• Now, a window will pop up where you change your File name and click on Publish.

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

Read More: Export Excel to PDF with Hyperlinks

3. Using ‘Fit Sheet on One Page’ Option

Another efficient method to save Excel as PDF without cutting off is by fitting the dataset to one page. This will automatically adjust all the columns and rows.

Steps

• First, go to the File tab in the ribbon and select the Print In the Settings option, there is a sub-option called No Scaling.

• 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.

• Now, go to the File tab in the ribbon and select Export.

• In the Export option, click on Create PDF/XPS.

• Now, a window will pop up where you change your File name and click on Publish.

• There we have the PDF format of our dataset without cutting off.

Read More: How to Convert Excel to PDF without Converter

4. Scaling Page to Save Excel as PDF without Cutting Off

Lastly, we can use the Scale to Fit command to save Excel as PDF without cutting off. In this method, we can alter the height, width, and overall scaling of the page.

Steps

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

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

• Now, go to the File tab in the ribbon and select Export.

• In the Export option, click on Create PDF/XPS.

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

• It will convert Excel to PDF without cutting off.

Read More: How to Convert Excel to PDF without Losing Formatting

Download Practice Workbook

Download this practice workbook and the PDF file.

Conclusion

We have shown the four most useful methods to save Excel as PDF without cutting off. All four methods are fairly easy to understand. I wish you enjoy the whole article and gain some valuable knowledge. If you have any questions, feel free to ask in the comment box.

Related Articles

• How to Save Excel as PDF on One Page
• How to Save Multiple Excel Sheets as One PDF
• How to Create a Fillable PDF from Excel
• How to Deal with Margin Problem While Converting Excel to PDF
• [Fixed!] Excel to PDF Size Problem While Printing
• [Fixed!] Excel to PDF Hyperlinks Not Working

<< Go Back to Export Excel to PDF | Export Data from Excel | Learn Excel