【 Create Labels in Excel 】 Step by Step Guide ▷ 2022

MS Excel is the program par excellence for create spreadsheets, spreadsheets and charts. However, there are a large number of different tasks that can be accomplished with this software.

In this sense, it is also a good complement to other programsexponentially increasing its profits.

In this post, we will see how through simple steps, we can create a series of labels for various uses. If you want to know more about it and use this method in your tasks, we recommend the following content.

How do labels work in Excel and when is it convenient to create them?

This is a very useful tool when you need to create a sequence of prints or other individual files. The same uses an excel sheet to generate an autocomplete record. That is, you can fill a document with several sheets from another program with a list made in a table.

This process is known as mailing labels, but it does not work exclusively for this purpose. As we can use it for multiple purposes. For example, if we have already created a price list of a great variety of products and we need to label them, we can do it with this method. Another opportunity to use it is when we have to issue diplomas or awards. In this way we only need to create two files: one with the data of the winners and another document with the design. The only thing we will have to tell the program is where to place each element.

Steps to Create Printable Email Address List Labels in Excel

As we mentioned before, there are different uses for this utility. However, they all agree that must be from an Excel file. Let’s see how to make this document and then transform it into printable labels.

• Create a blank book with excel.
• In the first row place the headings. In the example we use “Name, Surname, Address and Zip Code”. But you can use the ones you prefer. Keep in mind that each cell in this row will serve as a reference when distributing the elements in the other program.
• Fill in the fields that correspond to each category, the number of completed rows will be equal to the labels that we will create.
• Guard the document in a file and close Excel.

At this point, it is important to mention that this list can be used by different programs to create documents in sequence. For example, coreldraw use Excel files to generate sheets with the same design. However, in this case we will use Microsoft Wordwhich is included in the same Office package as the program we are dealing with.

• Opens a new text document.
• Go to the tab “Correspondence”.
• Locate the section “To create” and choose “Labels”.
• A small window will open, in the tab “Labels”Press the button “Options”.

• At the top of this new popup, choose the type of printer you have, usually they are “Page Printers”.
• Once chosen, press “New Label”.
• Here you shall determine the size of each one and on what sheet format you will print them. In the example you will see that it is a size of 5 x 9 cm, distributed in two columns and five rows. All this with 1 cm margins, 0.5 cm spacing and on an A4 sheet.
• In the first frame, add a name to this disposition to be able to use it later.
• Enter the dimensions you need and press “To accept”. Always taking into account that the quantity and size of labels does not exceed that of the sheets.

• Back in the first popup window, select “New document”. This action will create a new file, in which you will be able to see some dotted lines that delimit each label.
• Go back to the tab “Correspondence”.

• Press the button “Start Mail Merge” in the section of the same name.
• Choose “Labels…”.
• Select the layout created and press “To accept”.
• Then press “Select recipients” and right there “Use an existing list”.
• This is where you will need to locate the Excel file you created at the beginning.
• Once this is done, make sure to select the box “First row of data contains column headers” and press “To accept”.

• Back on the Word sheet, it’s time to locate the elements. For this you will use the button “Insert combo field” which is in the section “Write and insert fields”. You only have to do it in the first box.
• As you can see in the image, it is possible to change the order of the elements, as well as its size and other features. It is also allowed add text to it. These will apply to all tags.
• press “Update labels”.

• on the button “Finish and Combine” choose “Print documents” if you decide to take the labels to paper. Or if you have Adobe Reader installed you can convert it into a PDF document.