Formatting Issues

How to Create Avery 5160 Labels in Microsoft Word

Huda Qurayshi Sep 27, 2026 870 views

Question details

The user needs to generate formatting-ready labels using the Avery 5160 template within Microsoft Word.

How to Create Avery 5160 Labels in Microsoft Word

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating file folder or mailing labels with centered, large black text using Avery 5160 templates.
Observed behavior: The user wants to format and generate a complete sheet of Avery 5160 labels, requiring the use of Word's Mail Merge tool or label generation options.

Before you start

Ensure you have your recipient or label data ready in an Excel spreadsheet or Word table, and verify that you have blank Avery 5160 label sheets loaded properly into your printer.

Solution 1Recommended

Use the Step-by-Step Mail Merge Wizard

The most efficient way to generate multiple Avery 5160 labels with personalized or continuous data is by using Word's built-in Mail Merge Wizard.

The Mail Merge Wizard guides you through selecting the correct Avery template, importing your data list, and formatting the labels uniformly.

Open the Mail Merge Wizard

Navigate to the 'Mailings' tab on the ribbon. Click on 'Start Mail Merge' and select 'Step-by-Step Mail Merge Wizard' from the dropdown menu. A side panel will appear on the right.

Select Label Options

In the wizard panel, choose 'Labels' under 'Select document type' and click 'Next'. Then, click 'Label Options'. In the dialog box, set the Label Vendor to 'Avery US Letter' and select '5160 Address Labels' from the product list. Click 'OK'.

Choose the Data List

Click 'Next: Select recipients'. Choose 'Use an existing list' to browse for your prepared Excel file, or choose 'Type a new list' to manually enter your label text.

Format the First Label

Click 'Next: Arrange your labels'. Use the 'More items...' option to insert data fields into the first label. Highlight the text to center it and change the font to a large black style. Once formatted, click the 'Update all labels' button to replicate the formatting across the entire sheet.

Preview and Print

Click 'Next: Preview your labels' to ensure the layout looks correct. Finally, click 'Next: Complete the merge'. You can choose to 'Print' directly or 'Edit individual labels' to save the generated labels as a new Word document for future use.

Tip: Always print a test page on standard copy paper first. Hold it up to the light against a blank Avery label sheet to ensure the alignment is perfectly centered before printing on the actual label sheets.

Solution 2

Manually Create Custom Avery 5160 Dimensions

If the Avery 5160 template is missing from your version of Microsoft Word, you can manually input the precise dimensions to create a custom template.

Create and Print Labels Easily with WPS Office

WPS Writer provides a powerful, built-in Mail Merge tool that handles label creation effortlessly. You can easily import data, format text, and generate accurate print layouts using standard label dimensions like Avery 5160.

1. Launch WPS Writer: Open a new blank document in WPS Writer and navigate to the 'Mailings' tab.
2. Set Up Label Parameters: Click on 'Mail Merge' and choose 'Labels'. Select the vendor (e.g., Avery) and find the product number equivalent to 5160, or set custom dimensions.
3. Import Data Source: Click 'Open Data Source' to connect your Excel spreadsheet containing the label information.
4. Insert Fields and Format: Use 'Insert Merge Field' to place your data on the label. Apply your desired font, size, and alignment.
5. Merge and Print: Click 'Merge to New Document' to verify the final layout, then print the document onto your label sheets.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) files.Built-in Mail Merge feature supports standard label templates and custom dimensions.Free to use with a familiar, highly intuitive interface.Lightweight software that runs smoothly without slowing down your system.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my text not aligning correctly on the Avery 5160 labels?

Misalignment is most commonly caused by printer scaling settings. When you print the document, check your printer properties and ensure the scaling is set to 'Actual Size' or 'Custom Scale: 100%'. Ensure 'Fit to Page' is turned off.

Can I make a full page of the exact same label without using Mail Merge?

Yes. Go to the 'Mailings' tab and click 'Labels'. Type your desired text into the 'Address' box, select 'Full page of the same label', ensure the Avery 5160 template is selected in 'Options', and click 'New Document' to generate the page.

How do I add an image or logo to my Avery 5160 labels in Word?

During the Mail Merge process, before clicking 'Update all labels', you can use the 'Insert' tab to place a small image on the first label. Ensure the image's text wrapping is set to 'In Line with Text' or 'Square' so it doesn't disrupt the label dimensions, then click 'Update all labels' to duplicate the logo across the sheet.

Document & File Issues