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:
Other People Are Reading
Things you need
- Microsoft Word
Open a new document in Excel.
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.
Input the data into the appropriate columns in the spreadsheet.
Save and close the Excel document.
Open a new document in Word.
Open the "Tools" menu. Click "Letters and Mailings" and then "Mail Merge Wizard."
Under Document Type in the dialogue box, select "Labels."
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.
Select "Use an Existing List" under Select Recipients. Click "Browse" and then navigate to the Excel file and click "Open."
Select your table in the "Select Table" dialogue box. Check "First row of data contains column headers" then "OK."
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."
Select "Next: Complete the Merge." Save the Word file.
Turn on your printer.
Load a sheet of Avery 5160 labels into your printer. Exact methods for doing this will vary by printer model and style.
In Word, open the "File" menu. Click "Print."
Under the "Printer" section of the Print dialogue box, select the name of your printer from the Name drop-down menu.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for