To print labels in Word from Excel, prepare your address list with one person or destination per row, then use Word’s Mailings tab to start a label mail merge, connect the workbook, preview the labels, and print. You’ll need Microsoft Word and Excel, a saved workbook, and label sheets that match the product selected in Word. Print a test on plain paper before using the label stock.
What You’ll Need
- An Excel workbook: Put each label’s details in a separate row, with a clear column heading for each field, such as FirstName, LastName, Street, City, State, and ZIP.
- Microsoft Word for Microsoft 365: The steps below use Word for Windows. Word for Mac has the same basic mail-merge workflow, although some controls may be arranged or named slightly differently.
- Label sheets: Note the manufacturer and product number printed on the package. The label size and layout must match the stock loaded into your printer.
- A printer and plain paper: Plain paper is useful for checking alignment before you print on labels.
Step-by-Step
- Prepare the Excel list. Open the workbook and make the first row of the list a header row. Use a separate column for each piece of information you may want to show. For example, keep first and last names in separate columns if you want control over spacing or formatting in Word. Put one complete recipient in each row below the headings. Do not put a title, blank line, merged cell, or notes above the header row. Remove completely blank rows from the middle of the list, since they can become empty labels. Save the workbook as an .xlsx file and close it before connecting it to Word.
- Check values that need special handling. Format postal codes, customer IDs, and other values with leading zeros as text in Excel before entering or importing them. If Excel has already removed a leading zero from a numeric ZIP code, changing the format afterward may not restore it; correct the value itself. Make sure addresses are split consistently, and check spelling, punctuation, and capitalization. If you have a column for a country, include it only if it belongs on the labels. A little cleanup here is easier than correcting labels one by one later.
- Start a label mail merge in Word. Open a new blank document in Word. On the ribbon, select Mailings > Start Mail Merge > Labels. In the Label Options dialog, choose the label vendor and product number shown on your label package, then select OK. Word creates a page laid out as a grid of label cells. If you do not see the exact product, check the package for the manufacturer’s equivalent number or use New Label to enter the sheet’s dimensions and layout. Do not choose a product just because its labels look similar; small differences in spacing can cause misalignment.
- Connect the Excel workbook. Select Mailings > Select Recipients > Use an Existing List. Browse to the saved workbook, select it, and choose Open. If Word asks which table or sheet to use, select the worksheet containing the list. Select the option indicating that the first row contains column headers if Word presents it. The recipient list should now be connected. If a Select Table dialog appears, choose the correct sheet or named range, often shown with a dollar sign after the sheet name, and confirm.
- Review the recipients. Choose Mailings > Edit Recipient List to check that the intended rows are included. Clear the check box beside any person you do not want to print, or use the column filters and sort options to select a subset or arrange the labels. This is useful when the workbook contains several mailing groups. Confirm the list before continuing; the labels will be generated from the recipients currently selected, not necessarily every row in the workbook.
- Build the first label. Click inside the first label cell, then use Mailings > Insert Merge Field to add fields from the Excel headings. For example, insert FirstName, a space, LastName, press Enter, then insert Street, and add the remaining address fields on separate lines as appropriate. Type spaces, commas, or line breaks between fields where they should appear. The document may show field names in chevrons, such as «FirstName», rather than actual data. You can also use Mailings > Address Block for a standard address layout; open Match Fields there if Word has not matched your Excel headings correctly.
- Copy the layout to every label. Once the first label looks right, select Mailings > Update Labels. Word copies the layout across the label sheet and adds the Next Record instruction so each label uses the next recipient. This step matters: if you copy and paste the field layout yourself, every cell may show the same recipient. If Update Labels is unavailable, make sure you started a Labels mail merge rather than a directory or letter merge.
- Preview the results. Select Mailings > Preview Results. Word replaces the merge fields with actual data. Use the previous and next record arrows on the Mailings tab to inspect several labels, including the first, a middle record, and the last. Look for missing fields, unexpected blank lines, addresses that wrap awkwardly, and values that have lost leading zeros. Turn Preview Results off and adjust the first label’s layout if needed, then select Update Labels again and preview once more.
- Finish the merge and print a test. Select Mailings > Finish & Merge > Print Documents. In the dialog, choose all records or specify a record range, then continue to the printer dialog. For the first run, print to plain paper. Hold that page against a label sheet and check the alignment against a light source. If it lines up, load the label stock according to the printer’s instructions and print the labels. Use the printer’s actual-size or 100% scale setting; scaling the page to fit can shift the grid.
- Keep an editable merged copy if useful. Instead of sending the merge directly to the printer, choose Mailings > Finish & Merge > Edit Individual Documents. Select the records to merge and Word creates a new document containing the completed labels. Review that document, save it with a distinct name, and print it when ready. This is handy if you need to correct a single label or keep a record of exactly what was printed.
On Word for Mac: The same process is available from the Mailings tab: start a Labels merge, choose the label product, select recipients from an existing list, insert fields, and preview. Depending on the Word for Mac build, the labels and recipient commands may be displayed in a different arrangement on the ribbon. If you cannot find a command, check the Mailings tab and its menus. The Excel workbook should be saved locally or somewhere Word can access, and closing it before choosing it as the data source can help avoid connection issues.
Common Mistakes
- Choosing the wrong label product. A sheet with the same number of labels can still have different margins, gaps, or label dimensions. Match the exact product number, not just the number of rows and columns.
- Leaving the header row out or using unclear headings. Word uses the first row as field names. Headings such as Street, City, and ZIP are easier to match than blank or duplicated headings. Avoid blank column names and merged header cells.
- Forgetting Update Labels. Inserting fields in the first cell does not automatically set up all the other cells. Use Update Labels before previewing so each position advances to the next recipient.
- Printing directly on label stock first. A small alignment error can waste a whole sheet. Test on plain paper, verify the page orientation and scale, and compare the test against the label sheet before loading labels.
- Ignoring long addresses. A long company name, apartment line, or international address may overflow a small label. Preview the longest examples and adjust font size, line spacing, or the fields included before printing.
Tips
- Keep the source list simple. One recipient per row, one type of information per column, and a single header row make the data easier for Word to interpret. Keep notes and totals outside the recipient list.
- Use a clean address layout. Add a line break between the name and street, and between the street and city line. If you include city, state, and ZIP on one line, add punctuation and spaces between the merge fields in Word rather than expecting Excel to provide them.
- Check the longest entry, not just the first one. One unusually long organization name or street address can change how a label looks. Preview several records and make sure nothing is clipped at the bottom or right edge.
- Save both files in a known location. Keep the Excel workbook and the Word merge document together. If you move or rename the workbook later, Word may ask you to locate the data source again.
- Print in the correct orientation. Confirm portrait or landscape in the printer settings as appropriate for the selected label sheet. Use the printer tray and feed direction specified by its manufacturer, particularly when printing a single sheet of labels.
Troubleshooting
Word does not show the right Excel columns: Return to the workbook and confirm the data is on the worksheet you selected, the first row contains headings, and there are no blank rows or columns separating the headings from the data. Save and close Excel, then reconnect using Mailings > Select Recipients > Use an Existing List. If Word asks you to choose a sheet, select the one containing the actual list.
Every label repeats the same address: Check that you selected Update Labels after creating the first label. If the field layout was manually copied, restart the label layout or remove the repeated cells and use the Update Labels command. Then preview again; the later labels should show different recipients.
Labels are blank or fields show instead of data: Turn on Mailings > Preview Results. If the fields still do not resolve, confirm that the merge is connected to the correct workbook and worksheet and that recipients are checked in Edit Recipient List. If Word displays a field name that does not match your column heading, use Insert Merge Field to select the correct field or adjust the mapping in Address Block’s Match Fields option.
The labels are shifted on the sheet: First confirm that the selected Word product number matches the physical labels and that the printer is not scaling the page. Check paper size, orientation, and the printer’s label-feed instructions. If a plain-paper test is consistently offset, verify that the sheet dimensions and margins are correct. Avoid changing several settings at once; test one adjustment at a time.
ZIP codes or other values look wrong: Check the original cells in Excel. If a leading zero has already been discarded, restore it in the source data, preferably by storing the value as text. Reconnect or refresh the recipient list after saving, then preview that recipient before printing.
Frequently Asked Questions
Can I print labels from Excel without Word?
Excel can print worksheet cells, but it does not provide Word’s label mail-merge layout. Word is usually the more practical choice for fitting a recipient list to a specific commercial label sheet.
Do I need to arrange the Excel list in label order?
No. Keep one recipient per row. Word fills the label cells in the order of the selected records. Use Edit Recipient List to sort or filter the records before completing the merge.
Can I use only some rows from the workbook?
Yes. Choose Mailings > Edit Recipient List and clear recipients you do not want, or use the available filter options. You can also choose a record range in the Finish & Merge print dialog.
Why does my address block omit a field?
Word may not recognize a heading such as ZIP or Address Line 2 as the field it expects. In the Address Block settings, choose Match Fields and map the Excel columns to the appropriate address components. You can insert individual merge fields instead if you need more control.
Can I print one replacement label instead of a full sheet?
Yes. In Word’s Finish & Merge > Print Documents dialog, specify the record you need. To place a label at a particular physical position on a partly used sheet, create a merged document and arrange the required label in that position, taking care that the printer can safely feed the sheet.
Will the labels stay connected to Excel?
The main merge document can retain its connection to the workbook, but Word may need you to locate the file if it is moved or renamed. The separate document created with Edit Individual Documents contains the merged label text, so it is useful as a printable snapshot.
Related
- How to Move Tabs in Excel With the Keyboard
- Move Text Down in an Excel Cell: Two Easy Ways to Do It
- How to Move in Excel Without a Mouse
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Weekly Timesheet in Google Sheets: Setup and TipsYes. You can make a weekly timesheet in Google Sheets by listing each workday, entering start and end…
- Circular Reference Settings in Excel: How They WorkIn Excel for Microsoft 365 on Windows, turn on circular-reference calculations at File > Options > Formulas by…
- How to Add a Calendar Drop-Down in ExcelTo add a usable date drop-down in Excel for Microsoft 365 on Windows, put a date list on…
- Conditional Formatting in Microsoft Lists: How It WorksYes. Microsoft Lists can use conditional formatting to change how columns or rows look when their values meet…
- Excel Unmerge Cells Shortcut: Keys, Steps, and FixesIn Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U—one key…
- Outlook Mailbox Rules: How to Create and Manage ThemCreate a mailbox rule in Outlook by choosing a condition, such as who sent a message or words…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.