If you are looking for some special tricks to solve the problem of “Excel cutting off text when printing to PDF”, you’ve come to the right place. In Microsoft Excel, there are numerous ways to fix this problem. This article will discuss six methods to resolve the problem. Let’s follow the complete guide to learn all of this.
Excel Is Cutting Off Text When Printing to PDF: 6 Possible Solutions
In the following section, we will use six effective and tricky solutions to solve the problem of “Excel cutting off text when printing to pdf”. The six methods are: adjusting the page size, changing the orientation, using the “Fit Sheet in one page” option, scaling the page, adjusting column width, and wrapping the text. You should learn and apply these to improve your thinking capability and Excel knowledge. We use the Microsoft Office 365 version here, but you can utilize any other version according to your preference. We will print the following Excel sheet to PDF.
There are times when trying to print the worksheet, there may be possible to cut off the text. The problem will look like this. Here, we can see that the dataset’s right-side column’s text has been removed. Additionally, we can see that the column header text was cut off when printing to PDF.
Now, we are going to demonstrate how we can solve the problem.
Solution 1: Adjust Page Size
In the first solution, 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. Let’s walk through the following steps to solve the problem.
📌 Steps:
- First of all, go to the File tab, and select the Print option.
- Then, select the Letter option from the Settings section.
- From the Letter option, select A3.
- The print preview will look like this.
- Next click on Print. This is how you will be able to solve the problem.
Read More: How to Print Excel Sheet in A4 Size
Solution 2: Change Orientation
The page orientation change is the foundation of our second solution. Page orientation can be either in landscape mood or portrait mode. By default, Excel will show your dataset as a portrait mood. However, you can adjust the orientation based on the column and row numbers. Use the landscape mode for higher column numbers and portrait mode for higher row numbers. Let’s walk through the following steps to solve the problem.
📌 Steps:
- First of all, go to the File tab, and select the Print option.
- Then, select the Portrait Orientation option from the Settings section.
- 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.
- Next click on Print. This is how you will be able to solve the problem. The print preview will look like this.
Read More: How to Print Landscape in Excel
Solution 3: Using ‘Fit Sheet on One Page’ Option
Another efficient method to solve the problem is by fitting the dataset to one page. By doing this, all the columns and rows will be adjusted automatically. Let’s walk through the following steps to solve the problem.
📌 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.
- Next click on Print. This is how you will be able to solve the problem. The print preview will look like this.
Read More: How to Print Sheet on One Page in Excel
Similar Readings
Solution 4: Scale Your Page
Here, we will demonstrate another solution to solve the problem. In this method, we can alter the height, width, and overall scaling of the page. Let’s walk through the following steps to solve the problem.
📌 Steps:
- First of all, go to the File tab, and select the Print option.
- Then, select Page Setup.
- Therefore, the Page Setup window will appear.
- Then, select 1 in the Fit to option.
- Next, click on OK.
- Next click on Print. This is how you will be able to solve the problem. The print preview will look like this.
Solution 5: Adjust Column Width
In many cases, the column width is not enough, so all the text is included on the page. We need to increase the width of the random column in order to solve this problem. Let’s walk through the following steps to solve the problem.
📌 Steps:
- First of all, go to the Home tab, and then select the Cells option.
- Next, select the Format option.
- Finally, choose column Width from the drop-down menu.
- Then, change the column width based on your preference.
- Next click on Print. This is how you will be able to solve the problem.
Solution 6: Try Wrapping Text
Here, we will another solution to solve the problem. We will Wrap Text option to solve the problem. When printing to PDF, we need to select the cell and use Wrap Text to have it automatically adjust the height of the cell.
📌 Steps:
- Next, choose Top Align.
- Then, from the Print option, you have to select Open in Preview.
- This is how you will be able to solve the problem.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article. It contains all the datasets and methods in different spreadsheets for a clear understanding.
Conclusion
That’s the end of today’s session. I strongly believe that from now, you may solve the problem of “Excel cutting off text when printing to PDF”. If you have any queries or recommendations, please share them in the comments section below. Keep learning new methods and keep growing!
Related Articles
- How to Adjust Print Settings in Excel
- How to Print Multiple Sheets in Excel
- How to Make Excel Spreadsheet Bigger When Printing
- How to Print Excel Sheet in Full Page
- How to Print Excel Spreadsheet on Multiple Pages
- How to Print Horizontally in Excel
- How to Not Print Empty Cells in Excel
- How to Print Worksheet with Comments in Excel
- How to Print Comments in Excel
- How to Print Excel Sheet with Table
- How to Print Graph in Excel
