Sometimes we have to deal with large datasets. In most cases, one or two columns go to the 2nd page which makes the dataset bad to work on. In that case, we have to fit that large dataset into one page to maintain continuity. There are several procedures where you can show the page layout view on one page in Microsoft Excel. In this article, we will focus on how to show the page layout view on one page only in Excel. I hope you find this article informative.
How to Show Only One Page in Excel Page Layout View: 4 Easy Methods
To show the page layout view on one page in Excel, we have found four different methods through which you can have a clear idea. All of these methods are fairly easy to understand. To show all these methods perfectly, we take a large dataset that includes the order date, customer name, product id, order location, book name, authors, book type, and purchase price.
If you look at the page layout view, you will find the page is divided into two. On the first page, you will get six columns.
On the next page, you will get the other three columns.
We need to show all the columns on one page only in the page layout view. To do this follow the methods carefully.
1. Modifying Page Setup
Our first method is basically using the page setup option. Utilizing the page setup option, we want to show the page layout view on one page only. To understand this method, follow the steps carefully,
Steps
- First, go to the Page Layout tab in the ribbon.
- Then, click on Dialog Box Launcher in the bottom right corner.
- It will open up the Page Setup dialog box.
- Then, select the Page tab in the Page Setup dialog box.
- After that, from the Scaling section, select the Fit to option instead of Adjust to.
- Finally, click on OK to apply the change.
- Then, go to the View tab in the ribbon.
- From the Workbook Views group, select Page Layout.
- As a result, you will see the dataset on one page only. See the screenshot.
2. Altering Page Orientation
We can alter the page orientation to show the page layout view on one page only. By default, Microsoft Excel will show your dataset in portrait mode but by changing the orientation from portrait to landscape, you can get your desired solution. To understand this method properly, follow the steps.
Steps
- First, go to the Page Layout tab in the ribbon.
- Then, click on Dialog Box Launcher in the bottom right corner.
- It will open up the Page Setup dialog box.
- Then, select the Page tab in the Page Setup dialog box.
- From the Orientation section, change the orientation from Portrait to Landscape.
- Then, from the Scaling section, change from Adjust to 100% normal size to Adjust to 80% normal size.
- Finally, click on OK at the bottom right corner.
- Then, go to the View tab in the ribbon.
- From the Workbook Views group, select Page Layout.
- As a result, you will see the dataset on one page only. See the screenshot.
Similar Readings
3. Changing Page Width
We can change the page width and set it to one page. This will set all the columns on one page and show the page layout view on one page only. To understand the method clearly, you need to follow the steps carefully.
Steps
- First, go to the Page Layout tab in the ribbon.
- Then, from the Scale to Fit group, select the Width drop-down option.
- After that, change the Width from Automatic to 1 page.
- Then, go to the View tab in the ribbon.
- From the Workbook Views group, select Page Layout.
- As a result, you will see the dataset on one page only. See the screenshot.
4. Wrapping Text and Resizing Column Width
We can wrap text and resize column width to show the page layout view on one page only. When you have some large name in a column, then adjusting the column and wrapping text can be a perfect solution to fit them on one page. To understand the method clearly, you need to follow the steps.
Steps
- If you look at the dataset, you will see several columns are so large. With the Wrap Text option, you can adjust several lines and make the dataset fit on one page.
- To do this, select range of columns C to J.
- Then, go to the Home tab in the ribbon.
- From the Alignment group, select the Wrap Text option.
- Then, move the mouse cursor to the boundary line between two columns, and it will convert into resize icon.
- After that, do the resize according to your condition to fit on one page.
- While resizing the columns, the rows become congested
- In that case, you can resize row height accordingly.
- The resize icon will appear when you take the mouse cursor between two rows.
- Then, go to the View tab in the ribbon.
- From the Workbook Views group, select Page Layout.
- As a result, you will see the dataset on one page only. See the screenshot.
Things to Remember
- In the case of the page setup method, we can adjust our dataset on one page for both portrait and landscape orientations.
- If you resize the column width and row height properly, wrap text can be a perfect solution to show the page layout view on one page.
Download Practice Workbook
Download the practice workbook below.
Conclusion
To show the page layout view on one page only, we have shown four different methods through which you can keep your data on one single page. All of these methods are helpful and can be a valuable asset for day-to-day work. I hope we covered all possible solutions in this article. If you have further questions, feel free to ask in the comment box.
None of these work
Thanks, SOME, for sharing your problem with us. If you have already tried every method described above, you can try to change the margin of the page or you can decrease the font size to see if it works for you. If your problem still persists, then I recommend posting your issue and sharing your file on our Exceldemy Forum. This way, we can examine your problem and work towards resolving it.
Regards
Aniruddah