Excel: create label

With Microsoft Excel, you can calculate only tables, but also manage databases, to create labels. Here we will show you examples of how to print address labels. The same principle works also with other data sets, regardless of whether you are labeling your spice rack, new, or your own business cards want to create.

Excel with the label-feed data

Before you begin to create your labels, you need first a table of all the information that you want to print are stored.

Open Excel and create a new document.
In the first row of the table, enter the Headings for the individual columns. In this practice tip, we label the fields with name, surname, street, house number and so on.
Now enter line-by-line the information of each individual record in your table.
Save the spreadsheet and close Excel.

Labels in Word, create

To create the records in your Excel table labels, you can use the mail merge function in Word.

Open Word and select the tab "broadcasts".
Click left on the "labels" and in the subsequent dialog box "envelopes and labels" on the "options"button.
Select in the Drop-Down menu under "labels supplier" the manufacturer of your label sheets, and from the list, including the corresponding label number from. You can find this information on the packaging of Blank labels and, in General, also on the back of the individual sheets. Confirm your selection with a click on "OK".
Back in the dialog "envelopes and labels" click on the Button "New document" to a document to create a template with the selected label dimensions.
You select in your new document again the tab "mailings", click on "select recipient" and in the Drop-Down menu to "Existing list" to open your Excel spreadsheet with the data sets.
Then, select from the list the worksheet on which the relevant records are located. Make sure that the checkbox next to "First row of data contains column headings" is checked and click "OK".
Click on the "insert merge field" and Word opens a list of your column headings from the table again. Add all of the required information with a double-click, and click "Close".
Now you arrange the first label, the inserted fields. In our example, we put a space between first and last name and a paragraph before the code.
Once you are satisfied with the result, click in the "write and insert fields" on the small icon for the "label update". Word copies the data fields for all labels on the page.
With a click on the button "preview results", you can check the individual labels before Printing them again.
Click on the button "Finish and merge" and the Drop-Down menu on the "print documents".
Confirm in the Dialog with a click on "OK", that you want to print all the records.
Insert the blank label sheets into your printer and click "OK".

This practice tip was carried out with Office 2013, but also works in Office 2010. With Excel and Word, create the labels by the way only simply, but also a series of letters. How to do this, we will show you here.