HOW TO SET MULTIPLE WORKSHEET PAGE NUMBERS AT THE SAME TIME IN EXCEL

The Excel continuous page numbering steps are as follows:

Preparation materials: Excel

1.Run Excel and open the document to **.

2.Open Page Setup in File.

3.Open "Header Footer", and select "First Page, Total" for the header. page", and the footer selects "the first page, total? page", click "Confirm", and the page number is set.

4.Again, go to "Page Setup" from "File" and change the "Start Page Number (R)" of "Page" to 3.

5.Open "Header Footer", and select "First Page, Total" for the header. page", and the footer selects "the first page, total? page" and click "Confirm".

6.Then you can see that there are two more worksheets in the lower left corner, so that the 3 worksheets are completed consecutively.

1. First of all, we open the excel document that needs to be printed (the version is excel2007), click on the menu bar "Page Layout", and then click "Margins", "Custom Margins".

2. At this time, the "Page Settings" panel will pop up, we click the "Header, Footer" tab, and then click the "Customize Footer" button.

3. The "Footer" panel appears, we first select the page number insertion location, as shown in the figure, click it in the middle box, and then click the "Insert Page Number" button marked in the figure, and click OK.

4. At this time, we print the document, we can see the page number of each page, we can preview it first, and the effect after inserting the page number is shown in the figure below.

When we use Excel to print, we will set page numbers to prevent the order from being shuffled, but how to set page numbers in multiple worksheets. Let me bring you the method of multiple worksheets with consecutive page numbers in excel. Hope it helps!

How to set consecutive page numbers in Excel01Run Excel and open the document to**.

02Open "Page Settings" in "File".

03 Open the "Header Footer", and select "First Page, Total" in the header. page", and the footer selects "the first page, total? page", click "Confirm", and the page number is set.

04 Go to "Page Settings" from "File" and change the "Start Page Number (R)" of "Page" to 3.

05 Open the "Header Footer", and select "First Page, Total" for the header. page", and the footer selects "the first page, total? page" and click "Confirm".

06 Then you can see that there are two more worksheets in the lower left corner, so that the 3 worksheets are completed consecutively.

1. Open Excel, click Page Settings - >> Find the small arrow below and click it.

2. Enter the page setup page, switch to the header footer option, as shown in the figure, in the footer place, drop down to select the page number format you need, and confirm after selection, we generally choose "Page 1, total? page", which is more common.

<>4, here is divided into left, middle and right, three to the area to place the footer, mouse click can directly enter the text, at the same time, as shown in the figure of the part of the bright rise can be added to the parameters, there are page numbers, total number of pages, time, date, files, etc., by your free choice.

5. After setting, let's preview it and click Start->> Print.

6. Set the print of the entire workbook in the print settings, then the page numbers will be added automatically and continuously, but the premise is that you want to set the page numbers for each worksheet.

7. The entire workbook becomes 11 pages.

8. Quickly set the page number of the worksheet at one time: hold down Ctril or Shift, click on the working land source table, select all the worksheets, and then follow the previous tutorial and page settings to set the footer page number, and then you can do it at one time.

1. Open Excel, click on the page settings to find the small arrow below.

2. Enter the page setup page, switch to the header footer option, as shown in the figure, in the footer place, drop down to select the page number format you need, and confirm after selection, we generally choose "Page 1, total? page", which is more common, and I will use this as an example.

3. Of course, you can also customize your page number format, the format given by the system cannot meet your needs, click Custom Footer.

4. Here is divided into left, middle and right, three to the area to place the footer, mouse click can directly enter the text, envy at the same time, as shown in the figure of the part can be added to the parameters, there are page numbers, total pages, time, date, files, etc., by your free choice.

5. After setting, our brother or state will preview it and click Start - Print.

6. You will see the first worksheet I previewed, a total of 4 pages. Tuan.

7. Set the printing of the entire workbook in the print settings, the page number will be added automatically and continuously, and you must set the page number for each worksheet.

8. The whole workbook becomes 11 pages.

9. Quickly set the page number of the worksheet at one time: hold down Ctril or Shift, click the worksheet, select all the worksheets, and then follow the previous tutorial and page settings to set the footer page number, and it will be done at one time.

Continuous insert page number tutorial in excelInsert Page Numbers ContinuouslyStep 1: Like a worksheet.

Insert page number step 2: click sheet1, right-click, click to select all worksheets, then find that all worksheets are framed by dotted lines, indicating that all are selected.

Insert Page Number in Succession Step 3: Click on File-Page Setup, which is present.

Insert Page Number ConsecutivelyStep 4: The starting page number can be set without setting.

Insert Page Numbers ContinuouslyStep 5: Click Header & Footer - Custom Footer to enter.

Step 7: Of course, you can also fill in 10, and then start setting your page number at 11. The other numbers are similar.

You may also like:1excel how to set page number 2How to set the excel page number.

3.How to add page numbers when excel tabulation.

4.Excel**Automatic pagination and unpagination setting method 5excel how to batch old return type input consecutive date 6How to set the page number in Excel.

7.How to enter the same data into multiple worksheets at the same time in excel.

The specific steps to insert page numbers into all worksheets in excel are as follows:

The materials that need to be prepared are: computer,

Take win7 system, excel**010 version as an example:

1. First, right-click the worksheet tab below and select "Select All Worksheets".

2. Then click on the small arrow behind the page settings in the opening page layout.

3. Then click "Custom Footer" in the header footer in the pop-up window.

4. Then click in the pop-up window to select the desired page number position.

5. Then click the insert page number icon at the top and press enter to confirm.

The specific steps for setting consecutive page numbers in multiple excel files are as follows:

1. The first step is to open Excel, then click on the page settings to find the small arrow below, and click to enter, as shown in the figure below.

2. The second step is to enter the page setup page, switch to the header footer option, as shown in the figure below, in the footer place, drop down to select the required page number format, and confirm it after selection, for example, select "Page 1, total?" page.

3. Step 3: If the format given by the system does not meet your needs, click Customize Footer, as shown in the figure below.

4. The fourth step here is divided into left, middle and right, three to the district file filial piety domain to place the footer, click the mouse to enter the text directly, as shown in the figure below for the parameters that can be added, there are page numbers, total pages, time, date, files, etc., you can choose freely.

5. After the fifth step is set, you can preview it and click Start - Print, as shown in the figure below.

6. The sixth step will see the preview of the first Shen Sui worksheet, a total of 4 pages, as shown in the figure below.

7. The seventh step is to set the printing of the entire workbook in the print settings, and the page numbers will be added automatically and continuously, and the page numbers should be set for each worksheet, as shown in the figure below.

8. The entire workbook in the eighth step becomes 11 pages, as shown in the figure below.

9. Finally, if you need shortcut keys to quickly set the page number of the watch for work: hold down ctril or shift, click the worksheet with the mouse, select all the worksheets, follow the previous tutorial, page settings to set the footer page number, and you can complete it at one time, as shown in the figure below.