Current location - Recipe Complete Network - Complete cookbook of home-style dishes - How to make labels in batch in excel?
How to make labels in batch in excel?
Draw a label first, or use this screenshot as the background color, and the corresponding blank as the corresponding cell.

Put a cell with a line number outside the label, such as A 1.

Suppose the device name is in column: table1b.

Enter the formula in the blank cell of the device name, as well as in other locations.

=INDEX (table 1! $B:$B,A 1)

Then enter any value in A 1 and display the corresponding value in the corresponding position of the label.

If you want to print more than one page at a time, just copy and paste a few pages, and then adjust the position of the next input line number, you can only input one line number, and other references can be accumulated.