Home  >  Article  >  Topics  >  How to print the form on one piece of paper?

How to print the form on one piece of paper?

烟雨青岚
烟雨青岚Original
2020-07-18 14:19:0813878browse

Method: First open the excel table, click [Page Preview]; then click [Page Layout]; then adjust [Paper Orientation], [Paper Size] and [Margins].

How to print the form on one piece of paper?

Method:

Open the xls/xlsx file that needs to be printed.

How to print the form on one piece of paper?

Click the "Page Break Preview" button at the bottom of the Excel window to enter the "Page Break Preview" view.

How to print the form on one piece of paper?

#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.

How to print the form on one piece of paper?

You can adjust settings such as paper size, orientation, and page margins to make the content appear reasonably on one page.

How to print the form on one piece of paper?

According to the sample table content, select A3 landscape paper.

How to print the form on one piece of 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.

How to print the form on one piece of paper?

This puts all the content on one page.

How to print the form on one piece of paper?

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.

How to print the form on one piece of paper?

# Then set the paper size, orientation and margins according to the size of the required printing area.

How to print the form on one piece of paper?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn