To create a sheet of name labels in Microsoft Word, go to Mailings > Start Mail Merge > Labels, choose the label brand and product number that match your sheets, add names as a list or connect a spreadsheet, then preview and print. Have the label package nearby so you can check its product number, and print a plain-paper test before loading label stock.
What You’ll Need
- Microsoft Word for Microsoft 365 desktop on Windows, or Word for Mac. Mail merge and label options are most complete in the desktop app.
- Label sheets, if you plan to print. Note the manufacturer and product number printed on the packaging.
- The names you want to print. You can enter them in Word or prepare a spreadsheet with one person per row.
- A printer that supports your label paper size and type. Check its instructions for the correct paper setting and feed direction.
Step-by-Step
- Choose a label workflow. For a short list, Word’s built-in recipient list is convenient. For names you already have in Excel or expect to update later, use a spreadsheet as the recipient source. If you need only one or two labels and do not need to repeat the process, you can also type directly into the label grid after Word creates it.
- Start a label mail merge. Open a blank document in the desktop version of Word. On Windows, select Mailings > Start Mail Merge > Labels. In the Label Options window, select the label vendor shown on your package, then choose the matching product number. Confirm the label description and dimensions before selecting OK. Word creates a table representing one sheet of labels.
- Choose the correct label layout if the number is not listed. Check the package again for a product code; a similar-looking sheet may have different spacing or label dimensions. If your product is not in the list, choose New Label in Label Options. Enter a descriptive label name and the measurements requested, including label height and width, top and side margins, horizontal and vertical pitch, and labels across and down. Use the manufacturer’s measurements rather than estimating from the sheet. Save the custom layout, select it, and click OK.
- Connect or enter the names. For a spreadsheet, select Mailings > Select Recipients > Use an Existing List, choose the Excel file, and select the worksheet that contains the names. Make sure the first row contains clear column headings, such as FirstName and LastName, and that each person has a separate row. For a list you are creating now, choose Select Recipients > Type a New List. Enter each person in the New Address List window. Use Customize Columns if you want to remove unused fields or add a field such as Department. Save the list when prompted.
- Design the first label. Click inside the top-left label cell. Select Mailings > Insert Merge Field, then insert the name fields you need, such as FirstName, a space, and LastName. Add a line break or another field if useful—for example, put a person’s role on a second line. You can type ordinary text between fields, such as “Guest,” but avoid typing a sample name where a merge field should go. That would make the same name appear on every label.
- Format the label content. Select the text or merge fields in the first cell and use the Home tab to choose a readable font, size, alignment, and emphasis. Centering names can suit event badges, while left alignment may be easier to scan on filing or storage labels. Keep text away from the edges and avoid a font size so large that longer names may not fit. If the label has a fixed size, check a long name as well as a short one.
- Copy the layout to the other labels. In the Mailings tab, click Update Labels. Word fills the remaining cells with the design and adds a next-record instruction so each label uses the next person in the list. This is important: copying and pasting the first merge field into every cell without a next-record instruction can repeat the first person’s name across the sheet.
- Preview the names before finishing. Select Mailings > Preview Results. Use the record navigation arrows in the ribbon to check several entries, especially the first, last, and any unusually long names. Confirm that fields are mapped to the right columns and that spaces, punctuation, and line breaks look natural. Click Preview Results again to return to the field-code view if you need to make edits.
- Create the printable label document. Select Mailings > Finish & Merge > Edit Individual Documents. Choose all records, or specify a range if you only want part of the list, then click OK. Word creates a new document containing the merged labels. Review that document rather than assuming the preview guarantees every page is correct; multiple pages, blank records, or unexpected line wrapping are easier to spot there.
- Print a plain-paper test. Print one page on ordinary paper first. Hold it behind a label sheet against a bright light, or place the sheets together carefully, to see whether the text lines up within each label. Check printer settings for the correct paper size, orientation, scaling, and feed direction. Turn off options such as “Fit to page” if they change the label dimensions. When the test aligns, load one label sheet as directed by the printer manufacturer and print a single sheet to confirm.
- Print the label stock and save your work. In the merged document, choose File > Print, verify the printer and page settings, and print the required pages. Label stock can curl or jam if the printer does not support it, so follow the printer’s paper guidance. Save both the original merge document and, if useful, the completed merged document. Keeping the original lets you correct the source list or design and produce another batch later.
Mac note: Word for Mac has the same basic mail-merge approach, though the ribbon layout and dialog wording can differ slightly by release. Look under Mailings for the label and recipient commands. Check page size and printer feed settings in the Mac print dialog before using label stock. Word for the web may not provide the desktop label-mail-merge workflow; open the document in the desktop app if the commands are unavailable.
Common Mistakes
- Choosing a nearly matching label number: Similar products can have different margins or pitches. Match the exact product code, not just the number of labels on a sheet.
- Skipping Update Labels: The remaining cells may stay blank or repeat the first entry. Use the command after formatting the first cell and before previewing.
- Using unclear spreadsheet headings: Blank or duplicate column names can make the wrong data appear in the merge fields. Give each column a unique heading and keep one person per row.
- Printing straight onto label paper: A misfeed or scaling change can waste a whole sheet. Test on plain paper first, and check that the printer is not enlarging or shrinking the page.
- Ignoring longer names: A design that fits “Jo Lee” may clip a longer name. Preview the longest entries and adjust the font or layout before printing.
Tips
- Use a consistent format for names in your source list. If you need titles or departments, put them in separate columns so you can control where they appear.
- Keep a clean copy of the recipient spreadsheet. Remove empty rows and check for duplicate people before connecting it to Word.
- Use a plain, high-contrast font and leave a little space around the text. Decorative type may look attractive but can be hard to read at label size.
- If names need different styles or extra wording, edit the completed merged document after merging. Changes made there affect that batch, while changes to the original merge layout can be reused for future batches.
- For a small number of labels, you can select Mailings > Start Mail Merge > Labels, choose the sheet, then type directly into individual cells instead of connecting a list. This is quick, but it is less convenient to update or reproduce.
Troubleshooting
The text does not line up with the labels: First confirm the exact label product number and paper size. In the print settings, use the actual sheet size and disable scaling such as “Fit” or “Scale to paper size.” Recheck the plain-paper test and printer feed direction. If the product is custom, compare each measurement in Word’s New Label setup with the manufacturer’s specifications.
Every label shows the same name: Return to the merge layout and click Update Labels. Then preview results and check that the labels after the first include the next-record instruction. If you typed names manually, inspect the cells for accidental duplication.
A field shows a heading or the wrong information: In the source spreadsheet, make sure the header row is identified as field names and that the selected worksheet is the one with your data. Reinsert the correct field using Mailings > Insert Merge Field. If the source changed after you connected it, use Select Recipients to reconnect or update the list.
Some names are missing or blank: Check for empty rows in the source, confirm that the merge is set to include the intended records, and inspect the completed merged document for blank pages or records. Remove empty spreadsheet rows and repeat the merge if needed.
Word cannot find your label product: Search the packaging for a manufacturer and product code, then check the vendor list in Label Options. If it is not available, choose New Label and enter the manufacturer’s exact measurements. Do not use a template for a different product just because the labels appear close in size.
Frequently Asked Questions
Can I make name labels in Word without Excel?
Yes. Choose Mailings > Select Recipients > Type a New List and enter the names in Word. For only a few labels, you can also type directly into the cells after creating the label sheet.
How do I print just one name label?
Create the matching label layout, then type the name into the desired cell and leave the other cells empty. If you are using a merge, choose the record you need and consider printing to plain paper first. Many label sheets have already had labels removed, so avoid feeding a partly used sheet unless your printer and label maker say it is safe.
Can I use an Excel list for name labels?
Yes. Put one person per row, use a clear heading for each column, save the workbook, and connect it through Mailings > Select Recipients > Use an Existing List. Insert the desired name fields into the first label and select Update Labels.
How do I make the names bigger or centered?
Format the text or merge fields in the first label using the Home tab, then select Update Labels so the formatting carries across the sheet. Preview long names to make sure the larger size still fits.
Can I create name labels in Word for the web?
The desktop versions of Word provide the full label mail-merge controls. If the web app does not show the label or merge commands you need, open the file in Word for Windows or Mac, create and merge the labels there, then print from the desktop app.
Related
- How to Clear Cache in the Outlook Mobile App
- How to Clear Cache in Outlook Email
- How to Clear Cache in Outlook for Windows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Make Every Other Row a Color in Excel (2 Ways)To color every other row in Excel, format your data as a table and choose a banded style,…
- Applying Styles in Word: A Practical GuideTo apply a style in Microsoft Word for Microsoft 365 on Windows, select the text or place the…
- Excel Split Cells: Did Microsoft Remove the Feature?No—Excel did not get rid of a command that splits one cell into smaller cells; Excel has never…
- Excel Heatmap Guide: Create, Customize, and Read OneTo make a heatmap in Excel for Microsoft 365, select the numeric cells, then choose Home > Conditional…
- Google Sheets Filter Shortcut: Apply a Filter FastIn Google Sheets in a web browser, press Ctrl+Shift+L on Windows, Linux, or ChromeOS to create a filter;…
- Schedule an Email in Outlook: Step-by-StepTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send (or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.