Different Labels in Word: How to Make Each Label Unique

Formulas & functions · Updated November 3, 2026

Different Labels in Word: How to Make Each Label Unique

To create different labels on one sheet in Microsoft Word, start a label mail merge, connect a recipient list, add the fields to the first label, and choose Update Labels so Word fills each label with a different record. You can use an Excel list or type recipients directly in Word. Before you begin, check the product number on your label sheets so the page layout matches the stock you plan to print on.

What You’ll Need

  • Microsoft Word for Microsoft 365 on Windows, or a recent Word version with the Mailings tab.
  • Label sheets, if you plan to print on adhesive stock. Note the brand and product number printed on the package.
  • A recipient list with one row per label and column headings such as Name, Address, or Item.
  • A printer and plain paper for a layout test. You can still create and save the label document without a printer or label stock.

Step-by-Step

  1. Prepare the information for your labels. If you are using Excel, put each person, address, product, or other label entry on its own row. Use a clear heading in the first row of each column, such as FirstName, LastName, and Street. Avoid blank rows within the list, merged cells, and multiple entries in one cell. Save and close the workbook before connecting it to Word. For a small batch, you can enter the recipient details directly in Word instead.
  2. Start a label mail merge. In Word for Microsoft 365 on Windows, open a blank document and select Mailings > Start Mail Merge > Labels. In the Label Options dialog, choose the label vendor and product number that match your package, then select OK. If the exact stock is not listed, check the package for its dimensions or look up the manufacturer’s template information before selecting a similar size. A close but incorrect match can shift text onto the edges or between labels.
  3. Choose or make a matching label layout. In Label Options, look under Label vendors and Product number. If you cannot find the exact product, select New Label and enter the dimensions and page margins from the label manufacturer’s specifications. Give the custom layout a recognizable name, then save it. Do not estimate measurements by eye if you can avoid it; small differences in label height, width, or spacing can add up across a page.
  4. Connect the recipient list. On the Mailings tab, select Select Recipients. Choose Use an Existing List to browse to an Excel workbook, or select Type a New List to enter the details in Word. If you choose the workbook, select the correct sheet or table when prompted and confirm that the first row contains column headings. Word uses those headings to identify the fields you can place on the labels. To omit people or entries, use Edit Recipient List and clear the checkboxes beside the records you do not want.
  5. Build the first label. Word displays a grid that corresponds to the label sheet. Click in the first label, then add the information in the order and format you want. Use Mailings > Insert Merge Field to insert fields from your list, such as FirstName, LastName, or Address. Add spaces, punctuation, and line breaks between fields as needed. For example, a name label could have FirstName, a space, and LastName on the first line, with Department on the second. The field names are placeholders; Word will substitute each row’s actual values later.
  6. Set the appearance before copying the layout. Select the text or paragraphs in the first label and use the Home tab to choose a readable font, size, alignment, and paragraph spacing. Keep text inside the label’s printable area, leaving a little space at the edges. Avoid adding extra blank paragraphs that could push an address onto another line. If the label needs a logo or other fixed artwork, insert it into the first label and check its size and position before continuing.
  7. Fill the remaining labels with different records. On the Mailings tab, select Update Labels. Word copies the first label’s layout to the other cells and adds the record-advance instruction needed to move to the next recipient. This is the key step that makes each label different. Do not manually copy and paste the first label across the page without record-advance fields; that usually repeats the same person or entry on every label.
  8. Preview and check the results. Select Mailings > Preview Results to replace the field names with actual data. Use the previous and next record arrows in the Mailings tab to inspect several labels, including the first and last records. Check that names and addresses are in the right order, long entries fit, and no fields appear blank unexpectedly. If the preview looks wrong, turn Preview Results off, correct the first label, and select Update Labels again.
  9. Finish the merge and print a test. Select Mailings > Finish & Merge > Edit Individual Documents to create a separate document containing the completed labels. Choose all records or a range, then review the new document before printing. Print one page on plain paper first. Hold it behind a label sheet against a light to check alignment. If it matches, load the label stock according to your printer’s instructions and print the final copy. Save both the merge document and the completed labels document if you may need to reuse them.

On Word for Mac, the Mailings tab has the equivalent mail-merge tools, though their placement and dialog wording can vary by version. Look for Start Mail Merge, Select Recipients, Insert Merge Field, and Preview Results on that tab. The label choices are accessed through the Mailings label command; if a particular vendor or product is missing, use a custom label definition or the manufacturer’s Word template.

Common Mistakes

  • Forgetting Update Labels: Adding fields to the first cell does not automatically set up the rest of the sheet. Select Update Labels before previewing so the remaining cells advance through the list.
  • Choosing the wrong product number: Similar-looking label sheets can have different margins or gaps. Match the package number, not just the general label shape.
  • Typing field names instead of inserting fields: Text such as FirstName will print literally if typed as ordinary text. Insert it through Insert Merge Field so Word knows to replace it with recipient data.
  • Leaving out spaces or line breaks: Separate adjacent fields deliberately. Otherwise a first and last name may run together, or the city may appear on the same line as the street address.
  • Printing directly on label stock without checking: A small alignment error can waste an entire sheet. Test on plain paper first and make sure the printer settings use the correct paper size and scale.

Tips

  • Keep your source list simple: one record per row, one type of information per column, and descriptive headings in the first row. This makes fields easier to identify and update.
  • Use Preview Results to inspect more than the first record. A long company name or address later in the list may wrap differently from the shorter examples at the top.
  • For a partial sheet of labels, count the unused positions and make sure the merge starts in the correct position. Word’s standard label merge normally begins at the top-left cell; a partly used sheet may need a template or carefully adjusted layout.
  • Save the recipient list separately from the Word file. When you need a new batch, update the list and reconnect or refresh the data source rather than retyping every label.
  • Use a plain-paper alignment test in the same orientation and paper size as the label sheet. If the test is off, check printer scaling and paper settings before changing the label measurements in Word.
  • If you only need one or two non-repeating labels, it may be faster to create a label document and type directly into individual cells. Mail merge is more efficient when many unique labels need to be generated from a list.

Troubleshooting

Every label shows the same recipient: Return to the Mailings tab, select Preview Results, and check whether you used Update Labels after creating the first label. If not, turn preview off, format the first label, select Update Labels, then preview again. Also verify that the source list contains multiple records and that you did not filter it to a single entry.

Fields show as names such as «FirstName» rather than real details: This can be normal before previewing. Select Mailings > Preview Results. If the field names remain, confirm that the correct recipient list is connected and that the inserted merge fields match the column headings in that list.

Labels are shifted or the text is clipped: First confirm that the selected vendor and product number match the package. Then check that the printer is using the correct paper size and is not scaling the page with options such as Fit to Page. Test on plain paper again. If the stock is custom, verify its measurements and define it through Label Options rather than adjusting spaces in the text to compensate.

Some names or address lines are missing: Open the source list and check for blank cells, misspelled headings, or data stored in a different column than expected. Reconnect the correct worksheet if Word selected the wrong one. If some entries are simply longer, reduce the font slightly or simplify the label layout, then preview those specific records before printing.

The printer feeds the sheet incorrectly: Check the printer manual for how label sheets should face and whether the tray guides need adjustment. Use label stock supported by the printer, and do not run a sheet through repeatedly if labels are loose or peeling. Printer feed behavior varies, so the correct orientation is determined by the printer, not by a universal Word setting.

Frequently Asked Questions

Can I put different names on each label in Word?

Yes. Use a label mail merge with one person or item per row in the recipient list. Insert the desired fields in the first label, select Update Labels, and preview the results. Word then advances to another list record for each label position. If you type text manually into separate cells instead, each label can also contain different information, but that approach is slower for a large batch.

Can I make different label designs on the same sheet?

A standard label mail merge copies one layout to every cell, so it is designed for different content in labels with the same design and dimensions. For different designs, create a blank label document and format cells individually, or use separate label templates. Keep the physical label sizes and positions consistent with the actual sheet so the printed content lands on the stock.

Can I use an Excel list as the source?

Yes. Arrange the data in columns with headings in the first row and one label record per row, save the workbook, and connect it through Mailings > Select Recipients > Use an Existing List. Choose the worksheet that contains the data. Review the preview carefully, particularly for postal codes or other values where Excel may remove leading zeros if the column was not formatted appropriately.

How do I print only a few labels?

When you choose Finish & Merge > Edit Individual Documents or the print option, select a record range if you need only particular recipients. If you are using a partly used sheet, be careful: selecting fewer records does not automatically tell Word which physical label positions are already occupied. Use a matching partially used-sheet template or position the starting cell appropriately, and test on plain paper first.

Why does Word not list my label brand?

Some label products are not included in Word’s built-in list. Check the package or manufacturer’s website for a Word template or the exact page and label measurements. In Word, use the New Label option to define a custom layout when the measurements are available. Do not choose a different product merely because its labels look similar; the spacing and margins may not match your sheets.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.