Create Labels in Excel  Step by Step Guide ▷ 2020

Microsoft Excel is the program par excellence for create spreadsheets, charts, and graphs. 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 programs, exponentially increasing your 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 use an excel sheet to generate an autocomplete record. That is, you can fill a document with several from another sheet program with a list made in a table .xlsx.

This process is known as mailing labels, but it does not work exclusively for that 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 make diplomas or recognitions. In this way we only need to create two files: one Excel table with the data of the winners and another document with the design. The only thing that we will have to tell the program is where to place each element.

Steps to create printable labels from an email address list 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.

Tags Create Excel Table With Headers

  • Create a blank book with Excel.
  • In the first row put 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, Corel Draw uses Excel files of .csv extension to generate sheets with the same design. However, in this case we will use Microsoft Word, which is included in the same Office package as the program we are dealing with.

Correspondence tab labels

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

Create new tag

  • At the top of this new pop-up, choose the type of printer you own, they are usually “Page Printers”.
  • Once chosen, press “New label”.
  • Here you should determine size of each one and on what sheet format will you 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 at this disposal to be able to use it later.
  • Place the dimensions you need and press “To accept”. Always bearing in mind that the quantity and size of labels does not exceed that of the sheets.

New document label

  • Back in the first pop-up window, select “New document”. This action will create a new file, in which you can see some dotted lines that delimit each label.
  • Head back to the tab “Correspondence”.

Start tag combination

  • Push 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”.
  • Here you should locate the Excel file that you created at the beginning.
  • Once done, be sure to select the check box “The first row of data contains column headings” and press “To accept”.

Insert fields label

  • Back on the Word sheet, it’s time to locate the items. For this you will use the button “Insert combo field” found in 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, so also its size and other features. It is also allowed add text to it. These will apply to all labels.
  • Press “Update labels”.

Label Print Document

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

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment