Home > Topics > excel > body text

How to batch print according to template in excel

藏色散人
Release: 2020-03-16 10:02:33
Original
17374 people have browsed it

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"

How to batch print according to template in excel

Select the template printing in printing

How to batch print according to template in excel

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

How to batch print according to template in excel

How to batch print according to template in excel

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

How to batch print according to template in excel

Okay then select the template Table

How to batch print according to template in excel

Okay, start by selecting the add button on the right

How to batch print according to template in excel

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

How to batch print according to template in excel

#Then match the data source field for the number

How to batch print according to template in excel

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

How to batch print according to template in excel

Select to start printing

How to batch print according to template in excel

Wait until everything is completed

How to batch print according to template in excel

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template