The fastest way: use Word's mail merge with a label template

Open Word and go to the Mailings tab at the top. Click Start Mail Merge, then select Labels. Word will ask you to choose a label size — pick the one that matches your physical labels (Avery 5160 is the most common for standard address labels). Word will create a sheet with empty label boxes ready to fill.

If you have addresses in an Excel spreadsheet or a Word table, you can connect that data to your labels so Word fills them automatically. Click Select Recipients and choose your data source. Then click Insert Merge Field and pick the column headers (like "Name" or "Address") that correspond to each label. Word will populate every label on the sheet with the correct address from your list.

Once your labels are set up the way you want them, print a test sheet on regular paper first. Hold it up to your actual label sheet to make sure the text lines up correctly. Then load your label sheets into your printer and print.

Key Takeaways

  • The Mailings tab in Word has a Labels feature that creates a template matching your physical label size, usually Avery 5160.
  • You can type addresses directly into each label, or connect Word to an Excel file or table so it fills labels automatically from your data.
  • Always print a test copy on regular paper first to check that text aligns with the actual label boxes before printing on expensive label sheets.
  • If you only need a few labels, typing them directly is faster than setting up a mail merge; if you need dozens, mail merge saves time and reduces errors.

Typing addresses directly into labels

After you create your label template (Mailings > Start Mail Merge > Labels), Word shows you a sheet divided into label-sized boxes. Click inside the first box and type the address exactly as you want it to appear. Press Tab to move to the next label, or click directly into any box you want to fill.

Format the text the same way you would in any Word document — change the font, size, or alignment using the Home tab. If all your labels need the same formatting, select all the boxes first (Ctrl+A) and then apply the formatting once.

This method works best when you have fewer than 20 labels to create. For larger batches, setting up a mail merge takes a few extra minutes but saves you from typing each address by hand.

Connecting your address list to labels automatically

If your addresses live in an Excel file or a Word table, you can tell Word to pull them into your labels without typing anything twice. First, make sure your data is organized with one column for each part of the address — separate columns for first name, last name, street, city, state, and zip code work best, though you can use any structure as long as the first row contains column headers.

In Word, after you create your label template, click Select Recipients on the Mailings tab and choose Use an Existing List. Navigate to your Excel file or the Word document containing your address table and open it. Word will show you a preview of the data it found.

Now click inside the first label box and go to Insert Merge Field. A dropdown menu shows all the column headers from your data. Click the header for the first line of the address (usually "Name" or "First Name"), and Word inserts a placeholder like <<Name>>. Press Enter and repeat for each line — typically Name, Street Address, City, State, and Zip. When you finish, click Finish & Merge and choose Print or Edit Individual Documents.

Fixing alignment problems before you print

Label sheets are precise — if your text is even slightly off, it will print in the wrong spot. Always print a test page on regular paper first. Load plain white paper into your printer, print one sheet, and hold it up to an actual label sheet to compare. If the text lines up with the label boxes, you are ready to print on labels. If it is off, you need to adjust.

The most common fix is changing the margins. Go to the Layout tab, click Margins, and try Narrow. Print another test. If that does not work, click Margins again and choose Custom Margins. Try reducing the top and left margins by 0.1 inch at a time until the alignment matches your label sheet.

Some printers also have a slight offset built in. If adjusting Word margins does not fix it, check your printer settings — look for an option called "Print Position" or "Offset" in the printer preferences, usually found in Windows Settings > Devices > Printers & Scanners or on Mac in System Preferences > Printers & Scanners.

Using a custom label size if yours is not in the list

Word includes templates for the most common label brands and sizes, but if your labels do not match any of the built-in options, you can create a custom size. Go to Mailings > Start Mail Merge > Labels, and in the label dialog box, look for a button labeled New Label or Options (the exact name varies by Word version).

You will need the measurements from your label sheet — the height and width of a single label, plus the distance from the edge of the page to the first label (top margin and left margin). These are usually printed on the label sheet packaging or on the manufacturer's website. Enter these measurements into Word's custom label dialog, give your custom label a name, and save it. From then on, it will appear in your label template list.

Printing only some labels from your sheet

If you have a partially used label sheet and want to print only on the remaining labels, you can tell Word to skip the labels you have already used. After you set up your mail merge and before you print, click Finish & Merge and choose Edit Individual Documents. Word creates a new document showing all your merged labels.

Delete the label boxes you do not need (select the box and press Delete), then print the document. This way you use only the blank labels on your sheet instead of wasting them.

Frequently Asked Questions

Can I print labels from a Google Sheets file?

Word cannot directly connect to Google Sheets, but you can download your Google Sheets file as an Excel file (.xlsx) and then use that file in Word's mail merge. Open Google Sheets, click File > Download, and choose Microsoft Excel. Save the file to your computer, then follow the mail merge steps in Word using that downloaded file.

What if my label template is not showing up in the label size list?

Word includes templates for common brands like Avery, but not every label size. Check the label sheet packaging for the product number (like "Avery 5160"). Search for that number in Word's label dialog — it may be listed under a slightly different name. If it is not there, measure your labels and create a custom label size using the steps above.

How do I print labels in a different order than my address list?

After you click Finish & Merge and choose Edit Individual Documents, Word creates a new document with all your merged labels. You can cut and paste individual labels to rearrange them, or delete labels you do not want to print. Save this new document and print it instead of printing directly from the mail merge.

Can I add a logo or image to my labels?

Yes. Before you start the mail merge, click into the first label box and insert your image (Insert > Pictures). Resize it to fit the label. Then set up your address text below or beside the image. When you complete the mail merge, the image will appear on every label along with the merged address text.

Why is my text printing too small or too large on the labels?

Word sizes the text to fit the label box, but you can override this. Select all the text in your labels (Ctrl+A) and change the font size manually using the Home tab. Test on regular paper first to make sure the size looks right before printing on actual labels.