How to Create and Print Number Labels in Microsoft Word

To create sequential number labels in Microsoft Word, put one number per row in an Excel list, then use Word’s Mailings > Start Mail Merge > Labels workflow to place the numbers on a label sheet. Preview the results, print a test page, and then print the finished labels. You’ll need the label sheet’s product number or measurements and the full desktop versions of Word and Excel.

What You’ll Need

Microsoft Word for Microsoft 365 on Windows. Word for Mac also supports label mail merges, though some dialog names and controls may differ slightly.
An Excel workbook containing one number per row, with a clear column heading such as Number.
A label sheet, including its brand and product number. If it is a custom size, measure the label width, height, margins, and spacing between labels.
A printer that supports the label-sheet size and type. Have plain paper available for an alignment test.

If every label will show the same number, you can create the label layout in Word and type that number once, then copy it into each label cell. For a different number on each label, a mail merge is usually faster and less error-prone.

Step-by-Step

Make a numbered source list. In Excel, create a blank workbook and enter a heading such as Number in cell A1. Put the first label number in A2 and the next number in A3. Select both cells and drag the fill handle (the small square at the bottom-right of the selection) down to create a sequence. Check the final row and make sure there are no blank rows in the list. Each data row will become one label.
Preserve any leading zeros. If your labels need values such as 001, 002, and 003, store those entries as text rather than ordinary numbers. One simple approach is to type an apostrophe before each value, such as ‘001; Excel uses the apostrophe to treat the entry as text and does not show it in the cell. Confirm the cells display the exact number of digits you want. This prevents Word from turning 001 into 1 during the merge.
Save and close the workbook. Save the list as an Excel workbook in a location you can find, such as Documents, and give the file a clear name. Close it before connecting it to Word. Keeping the heading in the first row and the data in one uninterrupted column makes it easier to select the right records.
Start a label merge in Word. Open a new document in the Word desktop app. On Windows, choose 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 you have a custom sheet, choose New Label and enter the label dimensions, page size, margins, and horizontal and vertical pitch. Pitch means the distance from the start of one label to the start of the next, including the gap.
Connect the Excel list. On the Mailings tab, choose Select Recipients > Use an Existing List. Browse to the workbook, select it, and choose Open. If Word asks which table or sheet to use, select the sheet containing the numbers and confirm that the first row contains column headings. If a prompt asks whether to use the first row as headers, leave that option selected when your heading is in row 1.
Insert the number field in the first label. Click inside the first label cell in the document. Choose Mailings > Insert Merge Field and select Number. Word inserts a field such as «Number». Do not type the field name between angle brackets yourself; a real merge field is connected to the Excel column, while typed symbols are just ordinary text. You can format the field like other text by selecting it and using the Home tab to change its font, size, alignment, or weight.
Fill the remaining labels. On the Mailings tab, choose Update Labels. Word copies the first label’s layout into the other cells and adds a Next Record instruction before each later number. That instruction tells Word to move to the next row of the Excel list. If you skip this step, the sheet may repeat the first number on every label. Avoid manually copying the first label across the page unless you also add the record-advance instruction correctly.
Preview the numbers. Choose Mailings > Preview Results, then use the previous and next record arrows to inspect labels. Check the first, a middle, and the last record. Look for missing numbers, duplicates, extra spaces, clipped digits, or a number that has lost leading zeros. If the results are wrong, turn off Preview Results, fix the source list or merge layout, and preview again.
Finish the merge and test the layout. Choose Mailings > Finish & Merge > Edit Individual Documents to create a separate document containing the completed labels. This lets you inspect the full sheet before printing. Print one page on plain paper at actual size or 100% scale, without options such as Fit to Page. Hold it over a label sheet against a light to check alignment. If it lines up, load the label stock as directed by the printer manufacturer and print the final document.

On Word for Mac, use the Mailings tab to start the label merge, choose the label layout, connect the recipient list, insert the merge field, and preview the results. Some releases place options in slightly different menus or dialogs, so follow the labels shown in your installed version. Word for the web does not provide the full desktop mail-merge workflow; open the document in the desktop app to create or finish the merge.

Common Mistakes

Choosing a similar but incorrect label product. Two sheets can look alike but have different margins or spacing. Match the exact product number on the packaging, not just the number of labels per page.
Forgetting Update Labels. In a merge, putting the number field in the first cell alone does not create a proper sequence across the sheet. Use Update Labels, then preview several records to confirm later cells advance.
Printing at a scaled size. Printer settings such as Fit, Shrink, or Scale to paper can shift every label. Test with plain paper and print at 100% or Actual Size.
Using an inconsistent source list. Blank rows, a second heading, or unrelated data in the number column can create empty labels or unexpected records. Keep one heading and one value per row.
Assuming number formatting will carry over. Excel display formatting does not always appear in Word as expected. Store fixed-width codes with leading zeros as text, and verify them in Preview Results.

Tips

Keep the number field in its own label paragraph if you want it centered. Click in the first label and use Home > Center, or press Ctrl+E on Windows. On Mac, use Command+Shift+E to center a paragraph.
Use a test merge on plain paper before opening an expensive or limited label sheet. Mark the top of the test page so you can confirm which way the printer feeds the stock.
For labels with a prefix, such as ID-001, add the fixed text before the Number field in the first label, then choose Update Labels. Preview the merge to confirm the prefix appears on every label.
If you need several copies of each number, repeat that number on separate rows in Excel. For example, three rows containing 25 produce three labels marked 25. The merge prints one label for each row.
Save the merged document as well as the Excel source. The source list is useful if you need to make corrections or print another batch; the merged document is convenient for reprinting the exact results.
Keep the text comfortably inside each label’s edges. A large font may look fine on screen but clip when printed if the label is small or the number has many digits.

Troubleshooting

Every label shows the same number: Return to the main merge layout, select the Mailings tab, and choose Update Labels. Preview Results and move through the records. If numbers still repeat, confirm the Excel list has multiple data rows and that the merge field is connected to the intended column.

Word cannot find the list or the numbers are missing: Make sure the workbook is saved and closed, then reconnect it with Select Recipients > Use an Existing List. Choose the correct worksheet or table in the prompt. Check that the heading is in the first row and that the Number column has entries below it.

Zeros disappear or numbers look different: Reformat the source values as text in Excel and reconnect the list, or correct the entries so the zeros are part of the text itself. Then preview the merge again. Do not rely only on Excel’s display format to preserve fixed-width codes.

The print is shifted or does not match the label edges: First verify the label product selection and check that the document page size matches the stock. In the print dialog, use Actual Size or 100% and disable scaling. If using custom labels, recheck margins, label dimensions, and pitch. Test again on plain paper before loading another label sheet.

The last sheet has blank labels: This often happens when the number of records is not a multiple of the labels per page. Word may leave unused cells on the final page; that is normal. Check for unintended blank rows in Excel, which can create additional empty records.

Frequently Asked Questions

Can Word create number labels without Excel?
Yes. For a small batch, create a label layout with Mailings > Start Mail Merge > Labels, then type numbers into the cells manually. Excel is more practical when each label has a unique number or you may need to update the list.

How do I make every label show the same number?
For a mail merge, include that number on multiple rows in the Excel source—one row for each copy—and use Update Labels. For a very small sheet, you can also type the number in the first label and copy it into the other cells.

Can I make number labels with a custom size?
Yes. In the Windows Label Options dialog, choose New Label and enter the measurements for your sheet. Measure carefully, including the gap between labels, and test the result on plain paper. If the dimensions are not known, check the label maker’s specifications first.

Can I start numbering at a value other than 1?
Yes. Start the Excel list with the first value you need, then continue the sequence in the rows below it. Word uses the values in the source list; it does not require numbering to begin at 1.

Can Word print labels such as 0001 or A-001?
Yes. Store fixed-width values such as 0001 as text in Excel. For a combined code such as A-001, the source can contain the complete code, or you can put the fixed prefix in the label layout and merge the number field. Preview to confirm the exact output.

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.