A label is a name sticker that shows or marks the name of an item or for special identification purposes. One of the labels that are often used is the price tag. When you shop at the supermarket, you must have seen the price tags of goods.
If you create price tags manually, it is very tiring and too much time. But you don’t need to worry because Microsoft word can be used to create price tags.
How to make? Follow some of the steps below.
1. Create a list of items and prices in Microsoft Excel
Before entering Microsoft Word, you must first create a list of items and prices through Microsoft Excel. Of course, this is done to make it easier later, the method can be seen below:
- Open Microsoft Excel then, click File -> New->Blank Workbook.
- Once open, please type the name of the item and the price as desired.
- If all prices and item names have been made, please save first
The name of the item and the price that was created earlier will be the basis for making price tags in Microsoft Word.
Also read: How to Unprotect PDF Files
2. Price tag size creation in Microsoft Word
Now, after you create item names and prices in Microsoft Excel, now focus more on creating labels in Microsoft Word. You can see the steps below:
- Open Microsoft Word and make sure to use new paper. If still not, please go to File->New->blank document
- Then select the Mailings tab -> Create->Labels.
- After the Labels tab opens, go to the Options section.
- In it will appear a list of various label brands that you can choose. If you don’t find the label you want, then we have to make it ourselves.
- How to create your own label is to click New label.
- Inside there are sizes that you can fill. Try to fill in the width, height, margin, pitch, etc. as desired.
- If you are sure, the next step is to click OK.
- Then you select New Document
Before moving on to the next session, make sure you try printing first. This is done to avoid misplaced labels. If there is an error when printing, then you have to change the layout again.
Also read: How to Remove Protected View in Excel
3. Create labels and autofill rosters
Next is to create labels and also autofill rosters. You can see the steps below.
- After clicking New Document earlier, you see an empty table. Of course, this table must be filled with data that has been created in Microsoft Excel before.
- To fill in the template automatically, please go to the Mailings tab then click Select Recipient and select Use an existing List.
- Then select the Excel file that you created earlier. it should be noted that make sure the excel file used is really fixed or correct. if you enter the wrong file, then you have to start from the beginning.
- Then clip the previous open Excel file.
- Next, choose a sheet that lists the name of the item and its price. Then click OK.
- Then, please select the first section label box.
- Then click the Mailings tab->Insert Merge Field->item name
- Next select the price of the item or the name of the file that you have created.
- After that, you can set the layout of the name of the item and also the price of the item. You can also change the font, size, and line height as desired. Of course, it aims to be neater when it will be printed later.
- After filling in the first box, the next step is to fill in the second box. You don’t have to bother filling in manually because what you do is Copy-Paste from the previous label.
- So that the next label fills the next table, then just click on the section before the item name.
- Then, go back to the Mailings tab->Rules->Next Record.
- Later you will see the word “Next Record” before the Item Name.
- That way, the first and second label boxes are complete. Next is to enter the next label box.
- Please block and copy or copy all the text on the second label.
- Then paste or paste in the unfilled pliers label box. Fill it up to the last label box.
- If you have, first make sure all the label boxes have been filled in
- Then, go back to Mailing and click Finish & Merge->Edit Individual Document.
- Then, select All and click OK.
- Automatically, the label box will be filled with data based on the previously created data. Starting from the name of the item, the price of the item, and the additional name that you have created.
Done, you’ve created a list of price tags as you wish. Make sure to double check before printing.
See also: A3 Kertas Paper Size
4. Print Price Tags
The final touch is to print a price tag if you have a printer. The method can be seen below:
- Please select the File tab and select Print. In this section, you should not need to change the paper, size, margins, etc.
- Next, please try to print one page first. If it’s OK, you can print everything.
Those are some points on how to create a price tag with Microsoft Word. Hopefully this article can provide benefits.
