Create Individual Avery 5160 Labels in Word for Mac
Question details
The user wants to enter different addresses on individual Avery 5160 labels in Word for Mac.

- Product
- Microsoft Word for Mac
- Device & OS
- macOS
- Scenario
- Creating a sheet of Avery 5160 address labels with a different address in each selected label position.
- Observed behavior
- Entering an address in the Labels dialog can populate all 30 labels with the same address.
Have your addresses ready and check that your label sheets are Avery 5160. Menu names may vary slightly by Word for Mac version.
Create a blank Avery 5160 label table
Use this method to type different addresses into individual labels on one sheet.
In Word for Mac, open a document and choose Tools > Labels.
Choose Options, select Avery US Letter as the label vendor and 5160 as the product number, then confirm your selection.
Leave the address field empty, select the full-page label option, and click OK to create the blank label table. If your version offers New Document, use it to create the sheet.
Click the table cell corresponding to each label position and type or paste its address. Leave unused cells blank.
Choose File > Print and review the preview. Print a test on plain paper and compare it with a label sheet before printing on the actual labels.

Use Mail Merge for a larger mailing list
Use a Word or Excel data source to populate a sheet with multiple addresses.
Prepare address documents with WPS Writer
WPS Office is a free, lightweight alternative with a familiar interface for editing Word documents and working with mailing lists. Open compatible Office files in WPS as you move between applications; check label layouts and print alignment before using label sheets.

Frequently Asked Questions
Why does Word put the same address on all 30 labels?
The full-page option in the Labels dialog repeats the address entered there. To enter different addresses, leave the address field blank, create the label table, and type into each cell.
How do I select Avery 5160 in Word for Mac?
Choose Tools > Labels > Options, select Avery US Letter as the vendor, and choose product number 5160. The exact dialog labels may vary by Word version.
Can I print only one label on an Avery 5160 sheet?
Yes. In Tools > Labels, look for the single-label option and specify its row and column, or create a blank label table and enter the address in the cell for that position.
How can I use an Excel address list for labels?
Start a label merge from the Mailings tab, select Avery 5160, and choose Select Recipients > Use an Existing List to connect your Excel file. Insert the address fields, update the labels, and preview the results before printing.




