Durjoy Paul
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.
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.
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.
- 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 (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.
- 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.
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.
Read More: Export Excel to PDF with Hyperlinks (2 Quick Methods)
Similar Readings
- Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)
- Print to PDF Using Macro Button in Excel (5 Macro Variants)
- Excel Macro to Save as PDF with Filename from Cell Value (2 Examples)
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: 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.
