How to batch print according to template in excel

#How to batch print according to template in excel? Excel sets the template to print in batches, suitable for form information, etc.

First choose the diy toolbox

Recommended: "excel tutorial"

Select the template printing in printing

Okay, the dialog box will pop up. We first need to select the data source table

Set to print from line 2 to line 6 and print one line at a time

Okay then select the template Table

Okay, start by selecting the add button on the right

Select the first position that needs to be filled in in the template, Number

#Then match the data source field for the number

##Okay, follow the same operation to complete all matching

Select to start printing

Wait until everything is completed

The above is the detailed content of How to batch print according to template in excel. For more information, please follow other related articles on the PHP Chinese website!