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.

Don't forget to check out our site [ Ссылка ] for more free how-to videos!
[ Ссылка ] - our feed
[ Ссылка ] - join us on facebook
[ Ссылка ] - our group in Google+

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

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

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

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

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

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

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

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

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

свернуть