When we work with a large dataset in Excel, sometimes the dataset breaks into two pages. It is a common occurrence in our regular professional life. In this article, we will demonstrate five different methods to fit all columns on one page in Excel. If you are curious about it, download our practice workbook and follow us.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
5 Quick Ways to Fit All Columns on One Page in Excel
To demonstrate the approaches, we consider a dataset of 21 employees. We mentioned their ID in column B, their names in column C, gender in column D, residency area in column E, the total number of family members in column F, total income in column G, and total costs in column H. So, we can say that our dataset is in the range of cells B4:H25. Now, if we try to display the dataset through the Page Break Preview, the table will show, broken into two pages. We will show you how to fix it.
1. Changing Scaling Option from Print Window
We are going to use the Scaling features of Excel’s built-in Print option to fit all the columns on one page. In the Scaling menu, we can use two different options. The first one is the Fit Sheet on One Page, and the second one is the Fit All Columns on One Page option.
1.1 Fit Sheet on One Page
In this approach, we are going to use the Fit Sheet on One Page option from the Scaling menu. The steps of this method are described below:
📌 Steps:
- First of all, click File > Print. Besides it, you can also press ‘Ctrl+P’ to launch the print section.
- Now, click on the drop-down arrow of the last scaling option and choose the Fit Sheet on One Page option.
- You will see that the number of pages reduces to 1.
- By selecting your desired printer, you can print the dataset.
- Otherwise, go back into the Excel worksheet through the Back button.
- Then, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will see all the columns the dataset fitted on one page.
Thus, we can say that our working method worked perfectly, and we are able to fit all columns on one page in Excel.
1.2 Fit All Columns on One Page
In the following method, we are going to use the Fit All Columns on One Page option from the Scaling menu. The procedure of this approach is given as follows:
📌 Steps:
- At first, click File > Print. Besides it, you can also press ‘Ctrl+P’ to launch the print section.
- After that, click on the drop-down arrow of the last scaling option and choose the Fit All Columns on One Page option.
- You will notice that the number of pages reduced to 1.
- Then, select your desired printer, if you want to print the dataset.
- Otherwise, go back into the Excel worksheet through the Back button.
- Now, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will see all the columns the dataset fitted on one page.
Hence, we can say that our approach worked successfully, and we are able to fit all columns on one page in Excel.
Read More: How to Change the Printing Scale So All Columns Will Print on a Single Page
2. Modifying Page Setup
In this process, we will modify the Page Setup option to fit all columns on one page. The steps of this process are given below:
📌 Steps:
- First, in the Page Layout tab, click on the Page Setup dialog box launcher.
- A small window titled Page Setup will appear on your device.
- Now, in the Page tab, choose the Fit to option and keep the value of both boxes 1.
- Then, click OK to close the box.
- After that, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will see all the columns the dataset fitted on one page.
- Moreover, if you want to print this dataset, then you have to press ‘Ctrl+P’ to open the Print window and it will be as the image shown below.
In the end, we can say that our process worked effectively, and we are able to fit all columns on one page in Excel.
Read More: How to Fit to Page in Excel (3 Easy Ways)
3. Changing Page Orientation
In this case, we are going to do the modification in the Page Setup option to fit all columns on one page. The procedure of this process is explained below:
📌 Steps:
- First of all, in the Page Layout tab, click on the Page Setup dialog box launcher.
- As a result, a small window titled Page Setup will appear on your device.
- After that, in the Page tab, change the Orientation option from Portrait to Landscape.
- Finally, click OK to close the box.
- Then, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will see all the columns the dataset fitted on one page.
- In addition, if you want to print this dataset, then you have to press ‘Ctrl+P’ to open the Print window and it will be as the image shown below.
So, we can say that our approach worked successfully, and we are able to fit all columns on one page in Excel.
Read More: How to Fit Excel Sheet on One Page in Word (3 Simple Ways)
4. Changing Page Width in Scale to Fit Group
The Scale to Fit option locates in the Page Layout ribbon also helps us to fit all columns on one page. The procedure to fit all columns on one page is given below:
📌 Steps:
- At the beginning of this method, first, go to the Page Layout tab.
- Now, change the Width option Automatic to 1 page in the Scale to Fit group.
- Then, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will get all the columns the dataset fitted on one page.
- Moreover, if you want to print this dataset, then you have to press ‘Ctrl+P’ to open the Print window and it will be as the image shown below.
At last, we can say that our method worked precisely, and we are able to fit all columns on one page in Excel.
Read More: How to Adjust Page Size for Printing in Excel (6 Quick Tricks)
5. Adjusting Column Width
Adjusting the column width sometimes helps us to fit all columns of the dataset on one page. When we get the headers of the dataset are quite long, but the entities belonging to that column are short, then this method can be the best solution. The process is explained below step by step:
📌 Steps:
- If we look at our dataset, we will see the headers of columns G and H are long enough compared to their other cell values.
- To shorter the headers, select the range of cells G4:H4.
- In the Home tab, select the Warp Text command from the Alignment group.
- Now, move your mouse cursor to the boundary line between columns G and H. You will see the cursor will convert into a resize icon.
- Then, wild press on the left key of your mouse and drag the resize icon to your left.
- The column width will be adjusted.
- Similarly, follow the same process for column H.
- After that, in the View tab, click on the Page Break Preview option from the Workbook Views group.
- You will get all the columns the dataset fitted on one page.
- Now, if you want to print this dataset, then you have to press ‘Ctrl+P’ to open the Print window and it will be as the image shown below.
Thus, we can say that our procedure worked perfectly, and we are able to fit all columns on one page in Excel.
Read More: How to Stretch Excel Spreadsheet to Full Page Print (5 Easy Ways)
Conclusion
That’s the end of this article. I hope that this article will be helpful for you and you will be able to fit all columns on one page in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.
Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!
Related Articles
- How to Add Legal Paper Size in Excel
- Why Is My Excel Sheet Printing So Small (Reasons and Solutions)
- Excel Fit to Page Scale/Preview Looks Small (5 Suitable Solutions)
- How to Add A3 Paper Size in Excel (2 Quick Ways)
