How to set up the number in Excel to be automatically incremented every time it is printed

<><4. Click the [Worksheet] tab in the "Page Setup" window, find the "Row Number Column Label" in the [Print] area, check the checkbox in front of it, and the [OK] setting will take effect, as shown in the figure.

5. Now you can see the numbers of the ** rows and columns in the print preview, and the next time you print the file, Excel will automatically print these numbers to complete the rendering.

Tool Material: Excel**.

<>3.Click on the Print option and field the Hole in the drop-down menu to select the Print which is late to preview.

<>5.Click on the worksheet and check the row number column under the table of contents spine code of the worksheet, so that you can set the number to be automatically incremented every time it is printed.

You can set up a Serial Number column that uses the auto-increment feature. Each time you print, take the serial number of the last line, add 1 to it, then insert a new line and print. Here are the steps:

1.In the ** to be printed, add a new column named "Serial Number". 2.

Enter "1" in the first cell of the first row. 3.Select the first row of the serial number cell, move the mouse over the small black dot in the lower right corner until the cursor changes to a cross arrow, and then hold down the left button and drag down until you want to print the number of rows.

4.Right-click the title bar of the Serial Number column and select Format Unit Racket. 5.

In the "Numbers" tab, select the "General" type, and then click the "Auto-increment" checkbox at the bottom of "Left". 6.Click "OK" to close the formatting cell settings.

7.Before printing, select the number of rows you want to print, and then look for the last serial number in the Serial Number column. 8.

Set the print page to the number of rows that need to be printed, and set the next cell of the serial number column to the last serial number plus insert a new row and print. Note: Remember to save a backup before printing to prevent the data from being overwritten when you print.

Hello dear, you can increment the number plus 1 by setting the autofill function in excel. The specific steps are as follows:1

Enter the starting number in a cell, for example, "1001". 2.Select the cell, place the mouse on the small black dot in the lower right corner, when the cursor changes to a black cross, hold down the left mouse button and drag down until the desired number of numbers appear in the column.

3.Release the left mouse button and Excel will automatically fill in the number. 4.

In the ** that needs to be printed, add a column, enter the "Delivery Slip Number" and format the column as text. 5.Enter "=First Numbered Cell" in the Delivery Note Number cell in the first row, for example, "=A2".

6.Move the cursor over the small black dot in the lower right corner of the cell, and when the cursor changes to a black cross balance, hold down the left mouse button and drag down until the required number of delivery note numbers appear in the column. 7.

Release the left mouse button, excel will automatically increment the number and add When you do it, select the area that needs to be printed and print. Note: If you need to restart the number, you can re-enter the starting number in a new line and follow the steps above.

Tool Material: Excel**.

3.Click on the print option and select the print preview in the drop-down menu.

5.Click on the worksheet and check the row number column label under the table of contents of the worksheet, so that you can set the number to be automatically incremented every time it is printed.

Use the ready-made tool, check Increment print only and select the excel type.

<><4. Click the [Worksheet] tab in the "Page Setup" window, find the "Row Number Column" in the [Print] area, and check the checkbox in front of it.

5. Now you can see the numbers of the rows and columns of the model in the print preview, and Excel will automatically print these numbers when you print the file next time to complete the renderings.

Use this key to vertical the ready-made grinding book, check only incremental printing, and select the excel type of blind bright macro.

Create an Excel document, and the other steps are the same as above.

Open the Word document you want to print, click on the "Mail" menu, and in the "Start Mail Merge" option bar, select "Select Recipients" - Use Existing List

Find the excel file you just created in the pop-up window, and click "Huaiqing OK" after the pop-up window pops up

Place the cursor in the document where you need to insert the serial number, select "Lead Marker Insert Merge Field" in the "Write and Insert Fields" option bar, and click the word "Serial Number" in it to insert "Serial Number" in this position

In the "Complete" option bar, select "Finish & Merge" -- Print Document, if you select "All" in the pop-up dialog box, 50 copies will be automatically printed, and automatically numbered, if you need to print a custom number of copies, you can define it in the third item "From to yourself".