How to realize automatic copying and numbering in Excel?

If the first label data you enter is in A2:B6 area, please do not set the cell border line first. Please refer to the following steps:

1. Set the label border: select column A and column B, and then start-Conditional formatting-Create a new rule-Use a formula to determine the cells to be formatted-Enter = a1"> ““（not = $ a $ 1

2. Input formula: enter = if(a2 = ",",if (and (int (row ()/6) = row ()/column () = 2), left ($ b $6,4)&; Round (row ()/12,0), A2), and drop it down to B 12.

3. Copy the formula to generate E2-E 100 labels (two for each label):

(1) copy cell A8 (select this cell and right click-copy, instead of copying the formula in the cell! ); (2) Put the cursor in the address bar in the upper left corner of the whole table, change A8 to B 1200, and press Enter; (3) Hold down the Ctrl key +Shift key+Left arrow key ← and continue to press the Up arrow key ←. At this time, some shadows appear in the table; (4) Move the cursor arrow to the shadow, and right click-paste formula selectively (fx) to finish.

The screenshot of the label made by the above method is as follows.