[Fixed!] Cutting Off Text When Printing in Excel

Microsoft Excel is vastly used to organise data. Sometimes, we have to deal with a huge amount of data and organise them in different columns. It is not impossible to face the problem that some of the data along with the columns get cut off at the time of printing. There is nothing to be panicked. In this article, I am going to explain 6 smooth possible solutions to the problem of cutting off text when printing in Excel. I hope this article will help you if you ever face the problem.

For more simplification, I have used a detailed dataset on the information of a company’s employees. I have organised the data in the Name, Gender, Designation, Address, and State columns.

Excel Cutting off Text when Printing

If we try to print this page by giving the Print command from the File tab, we will be able to see in the Print Preview section that the Address and State columns get cut off. Now, we will try to print the entire dataset on one page.

Excel Cutting Off Text When Printing


Download Practice Workbook


6 Smooth Ways to Solve If Cutting Off Text Problem When Printing in Excel

1. Making Page Adjustment

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.
  • Next, select the Print option.
  • Then, select the Letter option from the Settings section.

Making Page Adjustment

  • From the Letter option, select A3.

Excel Cutting Off Text When Printing

In the Print Preview section, we can see that the entire dataset got adjusted on one page.

Excel Cutting Off Text When Printing

Now, you can click on Print to print the entire dataset without the text getting cut off.


2. Changing 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:

  • Go to the File tab first.
  • Then, select the Print option.
  • Next, select the Portrait Orientation option from the Settings section.

Changing Orientation

  • Now, select Landscape from the Orientation for our dataset, Landscape Orientation gives a proper output. That’s why we choose it.

Excel Cutting Off Text When Printing

We can see that the entire dataset got adjusted on one page in the Print Preview section.

Changing Orientation


3. Applying Size Feature

We can use the Page Size feature as the 3rd solution. Basically, Excel considers the page size for printing as Letter by default. But, with this paper size, all the columns may not be on one page. So with this solution, you can alter the page size to accommodate all the columns on one page. Now, let’s see the steps of this solution.

Steps:

  • Firstly, click on the Page Layout tab.
  • Select Size from the Page Layout Then, you can choose according to your demand from the page size options. Here, I have chosen A3 to keep all the columns on one page.

Applying Size Feature

Now, if you print the entire dataset, you will see that all the columns are on one page. There are no cutting off columns. We can confirm it by watching the Print Preview section.


4. 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. You just need to follow the following steps to execute it.

Steps:

  • Go to the File tab.
  • Then, select the Print option.
  • Next, select the No Scaling option from the Settings section.

Using Fit Sheet on One Page Option

  • Pick Fit Sheet on One Page option from the No Scaling section.

Excel Cutting Off Text When Printing

In the Print Preview section, we can see that the entire dataset got adjusted on one page.

Using Fit Sheet on One Page Option


5. Applying Print Area Command

You can use the Print Area command as the solution for cutting off Columns when printing. Now, follow the steps of the solution given below.

Steps:

  • As the first step, select the entire area that you want to print. In my case, I have selected cells A1:G26.
  • Next, go to the Page Layout tab.
  • Select Print Area from the Page Layout ribbon.
  • After that, pick the Set Print Area option.

5. Applying Print Area Command

You can cross match whether the selected area is ready to print or not in the Print Preview section.

Excel Cutting Off Text When Printing


6. Using Page Break Preview Option

Another very simple yet effective solution is to use the Page Break Preview option to solve the problem of cutting off text when printing in Excel. Please follow the steps mentioned below to execute it.

Steps:

  • At first, go to the View tab.
  • Next, select the Page Break Preview option from the View ribbon.

Using Page Break Preview Option

Now, you will see a blue dotted line as the border between the pages.

Excel Cutting Off Text When Printing

  • Extend the blue dotted line as far as you want to print the area on the first page.

Using Page Break Preview Option

We can see that there are no cutting off columns. We can confirm it by watching the Print Preview section.

Using Page Break Preview Option

Thus, we can solve the problem of cutting off text when printing in Excel.


Conclusion

That’s all for this article. In this article, I have tried to explain 6 smooth possible solutions as simple as possible to the problem of cutting off text when printing in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo