Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

[Fixed!] Excel Cutting Off Text When Printing to PDF

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.


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.


6 Possible Solutions If Excel Is Cutting Off Text When Printing to PDF

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.

 problem of “Excel cutting off text 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.

adjusting page size to solve the problem of “Excel cutting off text when printing to PDF”

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

show the output

Read More: [Fixed!] Excel Cutting Off Columns When Printing


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.

changing orientation to solve the problem of “Excel cutting off text when printing to PDF”

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

show the output

Read More: [Fixed!] Cutting Off Text When Printing 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.

use "Fit Sheet on one page" option to solve the problem of “Excel cutting off text when printing to PDF”

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

show the output

Read More: How to Print Selected Area in Excel on One Page (3 Methods)


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.

scale your page to solve the problem of “Excel cutting off text when printing to PDF”

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

show the output

Read More: How to Print to PDF in Excel VBA : With Examples and Illustrations


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.

adjust column width to solve the problem of “Excel cutting off text when printing to PDF”

  • Next click on Print. This is how you will be able to solve the problem.

Read More: How to Format Excel to Print (13 Simple Tips)


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.

try wrapping text to solve the problem of “Excel cutting off text when printing to PDF”


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.

Don’t forget to check our website ExcelDemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib

Saquib

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo