How to print excel in pages

How to set up excel tables to print on separate pages?

1.how to excel in a worksheet of multiple forms paged print

For example: now there are 4 forms in the workbook, I want to print a form on top of each sheet of paper, respectively, with 4 sheets of paper to print out.

Step 1: Go to the View tab and click Pagination Preview in the Workbook View option group;

Step 2: The above chart “Paging Preview” in only two pages, respectively, “Page 1” and “Page 2”. We will move the cursor in the lower right corner of the border, when the mouse becomes a double arrow, hold down the left button and do not let go, drag the border until you see “page 3” and “page 4” when you release the mouse;

Step 3: Now! Excel can print four pages out, but we also need to cut the top two forms to the following to do, cut the completion of the following chart:

Now paging has been completed, print the workbook, it will print four sheets of paper, each sheet of paper above a form, the following and then say how to automatically paged print!

Excel automatic paging page settings:

1. vertical/horizontal settings: Click the “Page Layout” tab, click the “Margins”, check the bottom of the “Custom Margins”. Custom Margins”, in the pop-up “Page Setup” in the “vertical” or “horizontal” can be selected;

Page Layout” tab. /p>

2. Pagination margin settings: then enter the “Margins” set the size of the margins on the top, bottom, left and right;

3. So the page header and footer settings: you can also customize the page to set up any eyebrow and footer.

4. Excel quickly insert page breaks and delete page breaks

First, the cursor will be positioned in the location of the need to add page breaks, and then click the “Page Layout” tab in the “Separators If you want to reset so the effect of page breaks, you can check the “Reset all page breaks”.

How to print Excel sheets in pages. Automatic paging. Cancel paging and other skills

Often in Excel to create forms, we can not just make a form, sometimes in a workbook may make more than one form. But we would like to print all the forms separately to each sheet of paper above, each sheet of paper above only one form, then, how should we realize it? There are many friends are to rebuild a new workbook, and then cut the form one by one to a new workbook, each workbook inside a form, and then finally one by one to print out. Although this method can be achieved, but the operation is more cumbersome. In fact, there is a better and simpler way to use Excel in the paging function, in a workbook to print out a number of forms, each sheet of paper above the print a form.

How to set up manual paging in Excel

Now there are four forms in the workbook, I want to print a form on each sheet of paper, respectively, with four sheets of paper to print out.

①Access to the “View” tab, click the “Workbook View” option group in the “Paging Preview”;

② The above chart “Paging Preview” in only two pages, respectively, “Page 1” and “Page 2”. We will move the cursor in the lower right corner of the border, when the mouse becomes a double arrow, hold down the left button and do not let go, drag the border until you see the “Page 3” and “Page 4” when you release the mouse; (as shown below)

③ Excel can now print out four pages out, but we also need to cut the above two forms to the following to do, cut the completion of the following chart:

Well, now paging has been completed, print the workbook, then, will print four sheets of paper, each sheet of paper above a form, the following and then say how to automatically paged print!

Excel automatically paging page setup

vertical/horizontal settings: Click the “Page Layout” tab, click the “Margins”, check the bottom of the “Custom Margins”, in the pop-up “Page Setup” can be selected “vertical” or “horizontal”;

Paging margins set up: and then go to the “Margins” to set up the upper, lower, left, right margin size;

So the page header and footer settings: you can also customize the page to set any eyebrow and footer.

Excel quickly insert page breaks and delete page breaks

First, the cursor will be positioned in the location of the need to add page breaks, and then click the “Page Layout” tab in the “Separator”, select “Insert Page Break” or “Delete Page Break”. If you want to reset so the effect of page breaks, you can check “Reset all page breaks”.

how to make excel spreadsheet from the specified part of the re-page to print

Page Printing Method I Note: For the purpose of demonstration, the need to print to see the effect of the pictures are printed by office’s print preview window for the demonstration of the screenshot. As shown in the figure, is a total of 10 pages of the form of documents, each page is a continuous print, it is assumed that the need to make the document from the 61st line from the start of a new page to print.

Exit Print Preview, back to the document, first move the mouse to select the 61st line of the entire line: click on the illustration, select the 65th line (i.e., the form of the 61st line). In turn, in excel’s menu bar, select “Page View” – “Separator” – click “page breaks”, as shown in the figure.

This time will return to the document, found that there will be a page breaks at the sign of a dotted line, this dotted line is only viewed when the mark to use, said that the success of the set page breaks, as shown in the figure. Note: This dotted line can be seen in the view, but will not be printed when we print.

This time we print when we can find the 60th line from the new page, this time the document has become 11 pages. These are suitable for as long as the print document part of the content, or the need to complete the document into several copies of the case of printing, in the work of the work will be often used.

Similarly, if the end of the print, the need to restore the document to the original situation without paging, we can also be carried out through a simple operation. First of all, select the excel menu bar, select “Page View” – “Separator” – click “Delete Page Break” option, as shown.

This time back to the document view page, you will find the original page breaks where the dotted line mark disappeared, which means that the operation to remove page breaks successful.

Tap on the print preview or print, then you will find that the document has not been paged to print, the document continues to change back to 10 pages.

Page Printing Method II

In addition to the above, the use of page breaks set to complete the page print, we can also use the method of delineation of the print area to page print. Suppose we want to document the form of the 61st to 72nd serial number of personal information to print out a separate page.

Back to the document view page, first of all, to maintain a separate page to print out the contents of the selected state, that is, select the 61 to 72 serial number of information content, in the excel menu bar, select “Page Layout” under the “Select Print Area “, continue to select the” set print area “.

Back to the document will be found to be set up to print the scope of the region of the dotted line of the logo, this time that the setup of the print area successfully.

Then we print the preview or print the document directly, you will see that this time was printed out only 61 to 72 of the list of contents.