How to Make Labels in Microsoft Excel

Written by ryan menezes
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make Labels in Microsoft Excel
Word can address envelopes using Excel data. (envelope image by Peter Baxter from Fotolia.com)

Microsoft Excel stores data for other Office applications to use. Microsoft Word makes address labels using its Mail Merge function, but an Excel document provides the source file. The programs work together, printing a series of labels using names and addresses from an Excel workbook. The label data needs its own worksheet, and Word handles the labels' layout.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Move your label data to a new, blank Excel workbook.

  2. 2

    Insert a row on top off the sheet identifying the fields. If the labels specify first names, last names, street addresses and cities, for example, then name the rows "First Name," "Last Name," "Street Address" and "City."

  3. 3

    Save the workbook as "Labels.xlsx."

  4. 4

    Close Excel. Open Word.

  5. 5

    Click "Start Mail Merge" from the "Start Mail Merge" tab in the "Mailings" ribbon.

  6. 6

    Click "Step by Step Mail Merge Wizard" from the drop-down menu. The "Select document type" menu will open.

  7. 7

    Select "Next: Starting document." Click "Use the current document."

  8. 8

    Select "Next: Select recipients." Click "Use an existing list."

  9. 9

    Click "Browse." Navigate to and select "Labels.xlsx."

  10. 10

    Select the workbook containing your label data. Click "OK."

  11. 11

    Click "Next: Write your letter."

  12. 12

    Click the document. Click fields from the menu on the right. Arrange them on the document to form your label.

  13. 13

    Click "Next: Preview your letters."

  14. 14

    Click the "Preview your letters" section's arrow icons to scroll through the addressees.

  15. 15

    Click "Next: Complete the merge."

  16. 16

    Click "Print."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.