Working on Excel, there will be times when you encounter Excel files with short or long content, even very long and occupying an area larger than 1 page when you print. Therefore, if you perform normal Excel printing , you will print in 2 pages even more than 2 pages, which can make it difficult to track or not ensure the saving factor. At this point, it is necessary and more important that you need to align the printed page on Excel so that it is appropriate, the most reasonable will be fine.
How to align printed pages on Excel
Align print pages in Excel
To be able to print files in Excel that fit snugly on paper size, and at the same time ensure aesthetics, there are many different alignments that can help you do this. In this article, we have selected the best alignments applied by various Excel users and have been successful.
1. Switch Vertical Printing to Landscape Printing and vice versa
Normally, by default, Excel spreadsheets will be in portrait mode, so when you print on A4 pages, depending on the content of the Excel spreadsheet to choose the most suitable print mode will be the most reasonable solution you should think of.
To be able to switch portrait to landscape printing, you just need to click on the Page Layout -> tab, then navigate to Orientation ->, then switch Portrait to Landscape .
2. Use the Page Break Feature In Excel
If your Excel file is too long, you can also Page Break to control the content or gather the necessary content in one page, while the page break will be gathered into other content.
To use the Page Break feature, you just need to go to Page Layout -> then select Breaks -> you choose to continue Insert page Break so that Excel automatically divides for you.
3. Select Print Area in Excel
In addition to printing in the usual way, you can also use the regional print selection in Excel. With this type of print area selection, you have complete control in printing the places you want to print.
To select the print area in Excel, highlight the area you want to print -> to Page Layout -> then select Print Area -> and click Set Print Area.
4. Recalibrate the page size
When you recalibrate the page size, it will help you make the most of the extra space that the default Excel application has set.
To re-align the paper size, in Page Setup -> select the Margins -> tab here, you can reset the paper size by aligning the right and left
5. Reset the size of the table
You can also reset the size of the table to best fit in Page Setup. In Page Setup , navigate to Page -> click on Fit to -> and enter the number in the page wide by and all sections.
Assuming you need to set the print copy to fit snugly on page A4 -> then at page wide by you enter it is 1
And at Tall you enter the number 0 (see image below).
The above article has just introduced and guided you some good ways to align printed pages in Excel to be the most standard and correct according to the wishes of users. Alternatively, you can also do the