Labels in Excel and Word: Mail Merge Step-by-Step Guide

To create a sheet of address or product labels, organize each recipient or item in a separate row in Excel, then use Word’s Mailings > Start Mail Merge > Labels tools to connect the list, place fields, preview, and print. You can also lay out a basic grid in Excel, but Word’s label templates are usually easier to align with pre-cut label sheets. Before printing, check the label package’s brand and product number.

What You’ll Need

Microsoft Excel and Word for Microsoft 365 on Windows. The steps are similar in the Mac apps, though some dialog controls may be arranged differently.
An Excel workbook containing the information for your labels, such as names and addresses or product names and codes.
A label sheet or roll, if you are printing physical labels. Find the manufacturer and product number on the packaging.
A printer that supports the label stock, and a plain sheet of paper for a test print.

Step-by-Step

Decide what each label should show. For mailing labels, common fields are name, street address, city, state or province, and postal code. For product labels, you might use a product name, SKU, price, or batch number. Decide the order and line breaks in advance. A label is small, so include only details that need to be read on the printed sheet.
Prepare the Excel list. Put one person, address, or product on each row. Put one type of information in each column, and give each column a clear heading in row 1, such as FirstName, LastName, Street, City, State, and ZIP. Start the records in row 2. Avoid blank rows or merged cells within the list; they can make it harder for Word to identify the data range. Keep the list on one worksheet and save the workbook.
Check the data before connecting it. Remove accidental spaces and confirm that names, addresses, and codes are in the right columns. Format postal codes, product codes, or other values with leading zeros as text in Excel so that a code such as 00427 does not become 427. Keep the headers simple and unique. If the workbook has multiple sheets, note the name of the sheet that contains the label records.
Choose the label template in Word. Open a blank document. On Windows, select Mailings > Start Mail Merge > Labels. In the Label Options dialog, select the label vendor and product number printed on the label package, then choose OK. If the product number is not listed, select a compatible size or use New Label to enter the label dimensions and spacing from the manufacturer’s specifications. Do not guess the dimensions if you are printing on pre-cut stock. On Mac, use the Mailings tab and the Labels option; the dialog layout can differ, so check the product-number and custom-size controls shown in your version.
Connect the Excel workbook. In Word, select Mailings > Select Recipients > Use an Existing List. Browse to the saved workbook and open it. If prompted, choose the worksheet that contains the records and confirm that the first row contains column headings. If a table or named range is offered, select the one that includes the complete list. The first label cell should now be ready for merge fields.
Insert fields into the first label. Click inside the first label, then select Mailings > Insert Merge Field and choose the fields you want. Type spaces and punctuation between fields where needed. For example, place FirstName, a space, and LastName on the first line; put Street on the second line; and put City, State, and ZIP on the third line with suitable spaces and punctuation. The field names are placeholders, not the final address text. Use Enter to control line breaks, and adjust the font and alignment on this first label.
Copy the layout across the sheet. Select Mailings > Update Labels. Word copies the first label’s field arrangement into the other label positions and adds the necessary next-record instructions. This step matters: without it, the sheet may repeat the first record or leave the other labels blank. If you change the layout later, make the change in the first label and select Update Labels again.
Preview the merged labels. Select Mailings > Preview Results and move through the records using the navigation arrows in the ribbon. Check several labels, not just the first one. Look for missing lines, unexpected blank fields, long names that do not fit, and postal codes that have lost leading zeros. If the records look wrong, turn off Preview Results, correct the Excel data or field layout, and preview again.
Print a test, then finish the merge. Select Finish & Merge > Edit Individual Documents if you want to review the completed pages before printing, or Finish & Merge > Print Documents to send them to the printer. First print on plain paper. Hold the test sheet behind a label sheet against a light to see whether the text lines up with the label boundaries. In the print dialog, select the correct paper size and printer settings, and print at actual size or 100% rather than using a fit-to-page option. Once alignment is right, load label stock according to the printer’s instructions and print the final sheet.

Making a basic label grid directly in Excel: Excel is useful for arranging and printing a simple grid, but it does not provide the same ready-made mail-merge label workflow as Word. If you need a one-off grid, use a blank worksheet, set the paper size and orientation under Page Layout, adjust margins, and size columns and rows to match the manufacturer’s label measurements. Add borders or text, then set the print area under Page Layout > Print Area > Set Print Area. Use Print Preview to check the page. Column widths in Excel are not a straightforward inch measurement, so this approach can take trial prints to align precisely. For a full sheet of labels populated from a changing list, use the Word merge method above.

Common Mistakes

Choosing a similar-looking label product: Labels with the same number across a page can still have different margins, gaps, or dimensions. Match the exact product number, or enter the manufacturer’s measurements for a custom label.
Leaving out column headings: Word uses the first row as field names. If the first row contains a person’s details instead, those details may be treated as headings and excluded from the labels.
Forgetting Update Labels: Formatting the first position does not necessarily populate the rest of the sheet. Use Update Labels after designing the first label, then preview the records.
Printing directly on expensive stock: A small printer scaling or feed difference can shift every label. Test on plain paper first and compare it with the stock.
Using Excel’s fit-to-page scaling: Scaling can change the label dimensions and throw off alignment. Print at actual size after checking the paper size and margins.
Assuming empty cells disappear cleanly: A blank field can leave extra spaces or a line break. Preview labels containing incomplete addresses and edit the source list or layout to handle them.

Tips

Keep a clean, reusable Excel source list and save a separate copy before making major changes. This makes it easier to correct records without rebuilding the label layout.
Use clear, short column headings without duplicate names. If you need two phone fields, for example, call them HomePhone and WorkPhone.
Use a readable type size and leave a little space around text. Long addresses may need a smaller font, but check the smallest labels in Preview Results before printing.
For mail addresses, consider whether apartment or unit numbers belong on the same line as the street. A consistent layout is easier to scan and less likely to wrap unexpectedly.
Load label stock in the direction specified by the printer manufacturer. Printers differ in which side faces up and which edge feeds first.
Save the Word merge document as well as the Excel list. The Word file retains the label layout and connection settings, so you can refresh or reuse the merge later.

Troubleshooting

Word cannot find the workbook or worksheet: Save and close the Excel workbook, then reconnect it through Mailings > Select Recipients > Use an Existing List. Confirm that you selected the correct file and worksheet. If the list is on a different sheet, check that sheet’s name and that its first row has headings.
Only one label appears, or every label repeats the same person: Confirm that you chose a Labels mail merge, inserted fields in the first position, and selected Mailings > Update Labels. Then use Preview Results to move between records.
Fields appear as codes instead of values: Turn on Mailings > Preview Results. If you are looking at the finished merged document, return to the main merge document to edit the fields and preview again.
Text is shifted on the label sheet: Check the selected product number, paper size, orientation, and print scaling. Make sure the printer driver is not shrinking or enlarging the page. Run another plain-paper test and compare the position of the first and last labels; a growing shift often points to the wrong label pitch or page scaling.
Postal codes lose zeros or numbers display oddly: Correct the values in Excel and set code columns to Text before entering or importing the data. Reconnect or refresh the merge as needed, then preview the affected labels.
Some labels are cut off: Shorten long text, use a slightly smaller font, or adjust line breaks in the first label. Update Labels and preview the full sheet again before printing.

Frequently Asked Questions

Can I create and print labels using Excel alone?
Yes, for a basic manually arranged grid, but Excel does not have Word’s convenient label merge templates. You must size the grid and check alignment yourself. For labels made from a list of many names or addresses, Excel is best used as the data source and Word as the layout and printing tool.

Do I need to sort the Excel list before merging?
No. Word generally uses records in the order they appear in the selected list. Sort the Excel data first if you want labels in a particular order, such as by last name, city, or product category.

Can I leave a field blank for some people?
Yes, but a blank field can leave an empty line or awkward spacing. Preview records with missing details and adjust the source data or label layout. If the missing information is optional, a layout that does not depend on that line may look cleaner.

How do I print just one label?
In Word, use Mailings > Start Mail Merge > Labels and connect the list as usual. Select Mailings > Edit Recipient List to choose the record you need, then preview and print. For a single label in a particular position on a partly used sheet, check your label manufacturer’s instructions; the available options depend on the template and Word version.

Can I use a custom label size?
Yes. In the Label Options dialog, choose New Label and enter the dimensions, margins, and horizontal and vertical pitch specified by the label manufacturer. Save the custom label definition, then print a plain-paper test to confirm alignment before using label stock.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.