Create labels in word 2016 from excel
One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting ( ). Of course, there are third-party solutions that are available for creating sequentially numbered labels. You should now have a document that has all your labels in it, and you can print them as desired. Merge the information to a new document.Make sure the label contents are formatted the way you need them. Create the sample label so that it has the word Exhibit followed by a merge field that represents the number being pulled from the Excel worksheet.Go through the steps of creating a new document consisting of labels and specifying your data source (the worksheet you created in step 1).This displays the Mail Merge Helper dialog box. In Word, choose Mail Merge from the Tools menu.For instance, if you need 175 labels, you would place a title in cell A1 (such as "Number") and the 175 numbers you need in cells A2 through A176. Create an Excel worksheet that has as many numbers in it as you need.Conceptually, you only need to do the following: If you prefer to not use the SEQ field to create the labels, you can also create them doing a mail merge.
![create labels in word 2016 from excel create labels in word 2016 from excel](https://i.ytimg.com/vi/1WX2ZVvYDvQ/maxresdefault.jpg)
All your numbering should now be correct. This updates all the fields in what you selected. Press Ctrl+A to select everything in the document.Thus, if you need a total of 125 labels, and you can get 3 labels per line, you should end up with 42 rows of labels. You want enough rows of labels to meet your entire needs. Press Ctrl+V for each additional row of labels you want.(Don't worry yet that they have the same numbers on them.) You should now have two rows of labels, correctly formatted. Press Ctrl+V to paste a new row of labels.Press the right arrow, which should place your insertion point immediately after (beneath) the first row of labels.Select the entire first row of labels and press Ctrl+C.Select the other, blank rows of labels and delete them.
![create labels in word 2016 from excel create labels in word 2016 from excel](https://www.barcoderesource.com/images/excelbarcode3.jpg)
You should now have a complete row of the labels.
![create labels in word 2016 from excel create labels in word 2016 from excel](https://study.com/cimages/videopreview/t2w8j44zxd.jpg)
![create labels in word 2016 from excel create labels in word 2016 from excel](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/07/11084432/24.png)