Musiha Mahfuza Mukta
Sometimes you may need to print out your data. In that case, if you are searching for the solutions to the problem of Excel cutting off Columns when Printing, then you have come to the right place. In this article, I will explain the solutions for not cutting off Columns when Printing in Excel.
Download Practice Workbook
You can download the practice workbook from here:
8 Solutions for Cutting Off Columns When Printing in Excel
Actually, there are numerous ways to fix this problem in Microsoft Excel. Today, I will demonstrate 8 solutions for not cutting off Columns when Printing. In addition, for your better understanding, I’m going to use a sample data set. Which contains 6 columns. They are Student ID, Subject, CQ(60), MCQ(40), Total Marks, and Grade.
There are times when trying to print the worksheet, it may be possible to cut off the Columns. The problem will look like this. Here, you can see that the dataset’s right-side column’s text has been cut off. Additionally, you can see that two columns are moved to the 2nd page when printing.
1. Using Page Setup Menu When Printing
By default, the printing page of Excel has its own setup. Basically, with that setup, all used Columns may not be printed within a single page. There is a huge possibility of cutting off Columns when Printing in Excel.
Here, you can consider the 1st solution as using the Page Setup menu for not cutting off Columns when Printing in Excel.
Solution:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you need to Click on the Drop-Down Arrow beside the Page Setup menu. Here you can also use Excel keyboard shortcuts ALT+P to go to the Page Layout ribbon.
At this time, a dialog box named Page Setup will appear.
- Now, you need to select the Print Preview option from that Page Setup dialog box.
As well as that, a new window named Print will open.
- Now, choose the Narrow Margins and Fit Sheet on One Page options from the Drop Down Arrow beside them.
Finally, you can see all six columns are on one page when printing.
Read More: How to Display Print Preview with Excel VBA (3 Macros)
2. Employing Size Feature
Here, you may use the Page Size feature as the 2nd 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.
Solutions:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you have to go to the Size command >> 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.
Now, if you print my data then you will see that all the columns are on one page. There are no cutting off columns.
Read More: How to Print Selected Area in Excel on One Page (3 Methods)
3. Use of Print Area Command
You can use the Print Area Command as the solution for not cutting off Columns when Printing in Excel. Now, follow the steps of the solution given below.
Solution:
- Firstly, you have to open your worksheet.
- Secondly, select the data. Here, I have selected the range B2:G25.
- Thirdly, from the Page Layout ribbon >> you need to go to the Print Area command >> Then, you have to choose Set Print Area.
- Finally, you must click on the Drop-Down Arrow.
At this time, a dialog box named Page Setup will appear.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- Finally, press OK.
Finally, you can see all six columns are on one page when printing.
Read More: Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
4. Applying Scale to Fit Group
Another efficient method to solve the problem is by fitting the dataset to one page. By doing this, not only all the columns but also all the rows will be adjusted automatically. Here, to do so, I will use the Scale to Fit group.
Solution:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> you need to click on the Drop-Down Arrow beside the Scale to Fit group.
At this time, a dialog box named Page Setup will appear.
- Now, you have to go to the Page command in the Page Setup dialog box.
- Then, you must click on the Fit to option.
- Finally, press OK.
Now, if you print my data then you will see that all the columns are on one page. There are no cutting off columns.
Read More: [Fixed!] Excel Cutting Off Text When Printing to PDF
Similar Readings
- How to Print Page Number in Excel (5 Easy Ways)
- Print Sheet on One Page in Excel (9 Easy Ways)
- How to Print Data with Excel VBA (A Detailed Guideline)
- Print Selected Cells in Excel (6 Effective Ways)
- How to Format Excel to Print (13 Simple Tips)
5. Employing Page Break Preview Option
Sometimes after following all the above solutions still Excel may cut off columns when printing. Now, I will demonstrate the most efficient and easy way to solve the problem. Here, I will use the Page Break Preview feature as the solution.
Solution:
- Firstly, go to the View tab from the top ribbon.
- Secondly, select the Page Break Preview option.
At this time, you will see some Blue lines. Which denotes the page border limit for printing. Moreover, the dotted Blue line denotes the page break for printing.
- So, put your Mouse on the dotted Blue line.
- Then, drag the Mouse Cursor to the last column of your data.
Here, I have attached an image of the new Page 1.
Now, if you print the sheet then you will get all the columns.
Read More: How to Print Excel Sheet with Lines (3 Easy Ways)
6. By Changing Column Width
In many cases, the column width is more than enough, so Excel cut off some columns when printing. Thus, I need to decrease the width of the random columns in order to solve this problem.
Solution:
- Here, you may go to the border line of a Column. Then, you will see the following Mouse Cursor.
- Now, move the Mouse Cursor to decrease the width of the column.
Lastly, you will see all six columns are on one page when printing.
Read More: [Fixed!] Cutting Off Text When Printing in Excel
7. By Reducing Font Size
There is one more solution for not cutting off Columns when Printing in Excel. The solution is to reduce the Font Size. Furthermore, this is not a good solution because you have to notice up to which your sheet remains readable. Because, if you do more decrement to the Font Size then you may not be able to read your print copies. Now, let’s see how to reduce the Font Size.
Solution:
- Firstly, select your data up to which you want to keep the same font size.
- Secondly, from the Home tab >> click on the Decrease Font Size. Here, I have made my tables Font Size 10.
Here, I have also reduced the title and subtitles font size. The Font Size of titles is 12. On the other hand, the Font Size of the subtitles is 11.
Now, if you print my data then you will see that all the columns are on one page. There are no cutting off columns.
Read More: Print Titles in Excel Is Disabled, How to Enable It?
8. Employing Orientation Command When Printing
The page orientation change is the foundation of this 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. In addition, you should use landscape mode for higher column numbers and portrait mode for higher row numbers. Now, to do so, I’m going to employ the Orientation command.
Solutions:
- Firstly, you have to open your worksheet.
- Secondly, from the Page Layout ribbon >> go to Orientation command >> Then, you may choose the Landscape option.
Here, the printed copies are still cutting off columns. Thus, I will do more steps.
- Now, go to the File tab from the top ribbon.
- Then, select the Print option.
As well as that, a new window named Print will open.
- Now, from the Drop Down Arrow of No Scaling >> choose the Fit All Columns on One Page option.
Now, if you print my data then you will see that all the columns are on one page. There are no cutting off columns.
Read More: How to Print Landscape in Excel (3 Easy Methods)
💬 Things to Remember
- If you are using the office 365 version of Excel then you can simply go to the Print option and choose Fit All Columns on One Page for keeping all the columns when printing.
Conclusion
I hope you found this article helpful. Here, I have explained 8 solutions for not Cutting off Columns When Printing in Excel. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
