HOW TO SORT PAGES IN AN EXCEL SHEET Have the number of pages printed on each sheet

Worksheet page numbers are arranged consecutively When Excel XP prints multiple worksheets, the page number of each worksheet is numbered from 1. If you need to arrange the page numbers of multiple sheets consecutively, you can use the following trick: first use the method described above to see the total number of pages in the first sheet, and then switch to the second sheet.

Click the Page Setup command under the File menu to open the Page Setup Header Footer tab, and then click the Custom Header (or Custom Footer) button to open the dialog box. Click the Left, Middle, or Right boxes as needed, and then click the button with the word " to put &[page]" into the box. If you want the first page of the second worksheet to follow the last page of the first worksheet, just enter the total number of pages of the latter after "&[page number]" (i.e., the last page number, for example, 11) to make it "&[page]+11" style.

If you want, you can also add the words "Page" and "Page" before and after "&[Page]+11" to make it "Page&[Page]+11" style. Finally, follow the continuous printing method of the worksheet, and you can get the worksheet with consecutive page numbers.

1. Right-click the worksheet tab at the bottom of the window, select all the worksheets, then click View-> Header and Footer on the menu, set the page number to determine the exit, and press print in the state of keeping the workgroup to arrange all worksheets into continuous page numbers.

2. Set the starting page number for each table, the first table is not moving, the second table is set to 2, the third sheet is set to 3, and so on.

File Page Setup page, notice that there is a starting page number setting below it.

When printing the entire workbook in Excel, set the printed table page numbers to be continuous, and the system can automatically generate them by inserting the page numbers.

The steps of the method are as follows:

1. Open the Excel** that needs to be operated, and click "Header and Footer" in the Insert tab.

2. Switch to the footer and click "Page Number" in the toolbar.

3. Return to Excel**, open the print preview through CTRL+P, and you can find that the operation of setting a continuous page number is completed.

The Excel print sheet has a setting for each page that uses the print title function of the page layout.

1. Open the Excel document with content, select the Chinese file with the cursor, and double-click the left mouse button.

The result is: <>

2. Click "Page Layout".

3. Click "Print Title".

4. Place the cursor on the box to the right of the top title line (r) and click the left mouse button.

5. Click the symbol on the right side of the box in the top header line (r).

The result is: <>

6. Select the title line that you need to have on every page.

7. Click the "Enter key" on the keyboard.

8. Click "OK".

9. Click Print Preview to check whether there is a required title line on each page.

Get the results on the first page:

Get results on other pages:

Notes:If you strictly follow the above steps, the fourth step of the operation "put the cursor on the right side of the title line (r) at the top, click the left mouse button" can be canceled, the third step is followed by the fifth step, the fourth step is to be familiar with the operation after the hand guess directly in the box to fill in the title line cell personnel use, directly fill in the fifth step directly after the sixth step operation.

1. Open Excel** on the computer.

Then click Page Layouts in the toolbar.

2. Click to enter the page waiter layout, and select the print title option in the page settings.

3. After entering the print title page, in the worksheet page, the top header row should be selected as the header.

to select a whole row of cells, and then click OK to set the header row.

4. Click on the conversation to determine the setting of the title line, and then click the print preview in the upper left corner to enter the print preview page.

5. After entering the print preview page, you can see that each page has the same header.

1. First of all, click the "Page Layout" tab above excel**, and click on the "Which Lanian Print Title".

2. Then click on the "Header and Footer" option in the open window.

3. After entering, click the drop-down menu in the "Footer" position, and select the "First Page, Total?" page.

4. Click the Li Trap OK button to generate the settings, and then you can display the page number and the total number of pages at the bottom of the page when printing.

The specific steps are as follows:

The materials that need to be prepared are: computer, excel**.

Take the 2010 version of Excel** as an example:

1. First of all, open the required excel**, click the small arrow behind the page settings in the open page layout.

2. Then click to open the "Header Footer" in the pop-up window.

3. Then click to open the "footer" in the pop-up window, select a footer style, and press enter to confirm.

4. Then click to open the "Print Preview".

5. Then you can see the page number displayed.