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

Get FREE Advanced Excel Exercises with Solutions!

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.


Download Practice Workbook

Download this practice workbook and the PDF file.


4 Easy Methods to Save Excel as PDF without Cutting Off

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.

Save Excel as PDF Without Cutting off

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.

Save Excel as PDF Without Cutting off

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.

Note:

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

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

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

Save Excel as PDF Without Cutting Off

Utilizing Page Size to Save Excel as PDF Without Cutting Off

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

Utilizing Page Size to Save Excel as PDF Without Cutting Off

Read More: How to Convert Excel to PDF with All Columns (5 Suitable Ways)


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.

Utilizing Page Orientation to Save Excel as PDF Without Cutting Off

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

Utilizing Page Orientation to Save Excel as PDF Without Cutting Off

Note:

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

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

Utilizing Page Orientation to Save Excel as PDF Without Cutting Off

Read More: Export Excel to PDF with Hyperlinks (2 Quick Methods)


Similar Readings


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.

Utilizing FIt to One Page to Save Excel as PDF Without Cutting Off

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

Utilizing FIt to One Page to Save Excel as PDF Without Cutting Off

Read More: Excel VBA: ExportAsFixedFormat PDF with Fit to Page (3 Examples)


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: Excel VBA to Print As PDF and Save with Automatic File Name


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, and don’t forget to visit our ExcelDemy page.


Related Articles

Durjoy Paul
Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo