The first thing we need to know is that Excel It is part of the Microsoft office suite, Office, which in turn integrates other very popular programs. Here we find Word or PowerPoint which sometimes complement each other, as we will see. In the case at hand, we are preparing to create a file that will help us to create a sequence of labels, for example, for later printing. The use of these results that we are going to obtain will depend on the needs we have.
Adapt the Excel sheet to the label data
As you can imagine, a very important element here is the data that will be part of these labels. Therefore, to achieve the objective that we are discussing, we open a blank document in the mentioned program and then we type the headings that we will use in the first row of the spreadsheet. Once we have defined the headers we need for the labels, we will have to fill in the corresponding data.
As you can imagine, with the exception of the row of headers, the number of remaining rows will correspond to the number of labels needed. Once we have all the data entered, we can save it in its default format, XLSX. Next, we are going to open the text editor that is part of the same office suite and that we mentioned before, we are talking about the popular Word.
Associate data to labels from Word
Once we have created the spreadsheet that we mentioned above with its corresponding format designed in Excel, we go to Word. At the top of the main interface we opted for the option of Correspondence menu, where on the left side we find the Labels button. This will allow us to create these elements that we are talking about in these lines, based on the data from the previously created file.
Next, in the new window that appears, click on the Leave Options button, which will allow us to create a new label with a single mouse click. Now we will have the possibility of establishing the size of the different parts of it, as well as assigning it a representative name. After that and when clicking on a new document, the Word work desk will be filled with the corresponding labels that we are going to use with its preset design.
Obviously they are still blank, since we have not indicated to the program the data source to use to fill in these elements that we are designing. Thus, once we have all the on-screen labelswe return to the Correspondence section, but in this case we are going to tell the program the data source to fill in the labels.
In this case we click on the drop-down list select recipients. Now we only have to click on Use an existing list. Here we load into the program the Excel file that we previously created with the tag content.
Facebook Comments
Disqus