How to make a desk card with excel

One,

Make a business card for each student in the class and put it on the desk as a desk card for the teacher to identify the students' names. The information needed for a desk card is: class, seat number, name and life motto. How to make a desk card quickly with office software?

Similar requirements:

Sending a large number of surface mail requires printing a large number of recipient names and addresses;

The class makes brand-name desk cards for each student;

Have a meeting to make table cards for each leader;

……

The actual effect is roughly as follows:

Now, following the footsteps of the ancients, let's see how to use word and excel to realize this function.

Note: word and excel used in this paper are Microsoft 20 10 versions.

1. Record data in excel.

Or take building a famous brand for every student in the class as an example. First, you must input these data information into excel.

Class seat number, name and life motto are in one column. The format is as follows, pay attention to the information in the first line.

2. Make a simple word template

This step is to make the word template you want to print. For example, as follows:

The method is very simple, just insert the shape rectangle, and the three boxes in the middle are used to add our text information, so remember to set it to add text, that is, convert it into a text box.

It is important to note that the graphic size should match the actual print size. You can check the actual size of the largest rectangle, otherwise if it is too big or too small, the final printing will be completed.

(Update: 20 170 126: Pay attention to changing the word wrapping form here. If it is embedded, the final generated document will have many tables in one page of word. If section break is added later, the final desktop card document will be one desktop card per page. )

3. Associate the text box with excel data.

This step is the most critical.

Select Mail Mail Merge Mail Merge Distribution Wizard in the menu bar.

A sidebar will appear on the right side of word, and the recipient will "choose another list" to find the excel database file you created.

When prompted, click Next below until the mail merge is complete.

Step 4 insert data

At this time, we need to add text information in the made text box.

Select Mail Insert Merge Field from the menu bar.

At this point, you will find that there are three columns of information in our excel table, which is the first line of our excel table.

Insert them into the text boxes we created respectively.

5. Change the display style of the card template

After the data is inserted, we can change the display mode of the text as needed, such as the font color size and other information. At this point, the adjustment is aimed at all students.

For example:

At this point, you can view each student's desk card in the above setting options.

You can set the outline of a text box without an outline, or you can fill a background picture for the desk card. These functions are relatively simple, and it will be clear when you click the mouse, so I won't go into details here.

6. Generate printed documents of the whole class.

Select Finish and Merge to edit a single document.

At this time, a new word document will be generated, and each page of this document is a student's desk card. If you want to change the desk cards of individual students, please make the changes in this word document.

20 170 126 update: By changing the text embedding method, the desktop card typesetting method of the document can be changed. For more information, see step 2.

In this way, we can conveniently give out the business cards of the whole class in batch print.

Second, the method of making students' desk cards and desk labels in batches by using word documents, hoping to help everyone.

Details are as follows:

1. First, please find the Excel icon in your computer, click to enter the main interface, and then open the target table.