How to Use Avery 5160 Labels on Excel

Written by ben jones
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use Avery 5160 Labels on Excel
You can print labels from Excel by using Word. (number background image by kuhar from

Excel is a spreadsheet program produced by Microsoft as part of its Microsoft Office software package. One cannot actually use Excel to print labels. However, one can use Excel to manage addresses or other data and then merge that data with Word, which can print labels based on a template. Mail merging simply involves taking information included in the Excel spreadsheet and importing it into the label template laid out in Word.

Skill level:

Things you need

  • Microsoft Word
  • printer

Show MoreHide


  1. 1

    Open a new document in Excel.

  2. 2

    Title each column with the type of data you will use in your labels. For example, if you plan to print address labels, the first column would be titled "name," the second column would be titled "address," and so on.

  3. 3

    Input the data into the appropriate columns in the spreadsheet.

  4. 4

    Save and close the Excel document.

  1. 1

    Open a new document in Word.

  2. 2

    Open the "Tools" menu. Click "Letters and Mailings" and then "Mail Merge Wizard."

  3. 3

    Under Document Type in the dialogue box, select "Labels."

  4. 4

    Select "Label Options" to open the Label Options dialogue box. Select "Avery Standard" from the Label Products drop-down menu. Then select "5160 - Address" in the Product Number menu box.

  5. 5

    Select "Use an Existing List" under Select Recipients. Click "Browse" and then navigate to the Excel file and click "Open."

  6. 6

    Select your table in the "Select Table" dialogue box. Check "First row of data contains column headers" then "OK."

  7. 7

    Select the column titles from your Excel file that correspond with the Word identifiers in the Mail Merge Recipients dialogue box. The labels in Word will use identifiers such as "name" or "address."

  8. 8

    Select "Next: Complete the Merge." Save the Word file.

  1. 1

    Turn on your printer.

  2. 2

    Load a sheet of Avery 5160 labels into your printer. Exact methods for doing this will vary by printer model and style.

  3. 3

    In Word, open the "File" menu. Click "Print."

  4. 4

    Under the "Printer" section of the Print dialogue box, select the name of your printer from the Name drop-down menu.

  5. 5

    Click "OK."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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