How to Create Labels in Word 2013 Using an Excel Sheet

In this HowTech written tutorial, we’re going to show you how to create labels in Excel and print them out in Word.

If you wanted name tags, IDs, or anything of the sort that can be made into labels, it’s handy to print them out at home onto special office sticker paper designed specifically for labels.

To get started, open up Excel and in the column headers type in the categories of information to be shown.

open up Excel

In the following rows, type in the information that will differ from label to label.

type in the information

When finished, save the Excel document in an easily accessible location.

save the Excel document

Open up Word and go to the Mailings tab and hit Start Mail Merge, then click Labels.

click Labels

Choose your product vendor and product number (they may be found on the packet in which the labels are enclosed in).

Choose your product vendor and product number

Select Recipients, choose Use an Existing List, then select the Excel document you just made earlier, and finally hit OK.

choose Use an Existing List

Using the first label section, click Insert Merge Field and choose the field to show. Go ahead and finish inserting the last merge fields.

click Insert Merge Field

When finished, hit Update Labels. You may also Preview Results. When finished, hit Finish & Merge and choose the option that fits.

hit Update Labels

This is a HowTech tutorial, visit our website and see our videos for more!