5] Create the labels from Excel in Word At this point, Microsoft Word should have all the data needed to generate labels. With all this information, Word will showcase the data for each label inside.

To create a formula, click inside the cell where you want the product to appear and go to the "Layout" tab of the Word Ribbon. Click the "Formula" icon and enter "=PRODUCT" in the "Formula" field.