Method: First open the excel table, click [Page Preview]; then click [Page Layout]; then adjust [Paper Orientation], [Paper Size] and [Margins].
Method:
Open the xls/xlsx file that needs to be printed.
Click the "Page Break Preview" button at the bottom of the Excel window to enter the "Page Break Preview" view.
#Excel has paginated the content and divided it into 4 pages by default.
If you print directly like this, there may be two empty pages.
You can adjust settings such as paper size, orientation, and page margins to make the content appear reasonably on one page.
According to the sample table content, select A3 landscape paper.
After setting up, I found that there are still two rows of data that exceed one page.
At this time, you can make the two extra lines on page 2 fit into page 1 by fine-tuning the margins.
This puts all the content on one page.
Of course, sometimes the table contains a lot of content. You can set the "print area" to print only part of the content.
First select the area that needs to be printed, and then click "Print Area" → "Set Print Area" on the toolbar.
# Then set the paper size, orientation and margins according to the size of the required printing area.
Recommended tutorial: "excel tutorial"
The above is the detailed content of How to print the form on one piece of paper?. For more information, please follow other related articles on the PHP Chinese website!