Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Sequentially Numbered Labels.

Sequentially Numbered Labels

by Allen Wyatt
(last updated August 21, 2015)

11

If you work in a business where you need to sequentially number items, you might be wondering if there is a way you can use Word to create the labels for you. Word has many ways you can implement some type of numbering in your documents. For instance, you can use different fields for numbering, or use numbered lists, the captioning feature, or you can use mail merging. While all of these features (and more) use some type of numbering in them, they are not all well suited to creating labels.

Perhaps the easiest way to set up labels that have sequential numbers is to use the Envelopes and Labels capability of Word in concert with the SEQ field. Simply follow these steps:

  1. Use the Envelopes and Labels option from the Tools menu to create a sheet of blank labels.
  2. In the top-left label, type the word Exhibit, followed by a space.
  3. Press Ctrl+F9. Word inserts a pair of field braces in the label.
  4. Type SEQ and a space.
  5. Type a name for this sequence of numbers, such as "exhibit" (without the quote marks).
  6. Press F9. The field is collapsed and a number appears in your label.
  7. Format the contents of this first label any way you desire.
  8. Copy the first label by selecting it and pressing Ctrl+C.
  9. Select each of the other labels in the first row in turn, and press Ctrl+V. You should now have a complete row of the labels.
  10. Select the other, blank rows of labels and delete them.
  11. Select the entire first row of labels and press Ctrl+C.
  12. Press the right arrow, which should place your insertion point immediately after (beneath) the first row of labels.
  13. Press Ctrl+V to paste a new row of labels. You should now have two rows of labels, correctly formatted. (Don't worry yet that they have the same numbers on them.)
  14. Press Ctrl+V for each additional row of labels you want. You want enough rows of labels to meet your entire needs. Thus, if you need a total of 125 labels, and you can get 3 labels per line, you should end up with 42 rows of labels.
  15. Press Ctrl+A to select everything in the document.
  16. Press F9. This updates all the fields in what you selected. All your numbering should now be correct.

If you prefer to not use the SEQ field to create the labels, you can also create them doing a mail merge. Conceptually, you only need to do the following:

  1. Create an Excel worksheet that has as many numbers in it as you need. For instance, if you need 175 labels, you would place a title in cell A1 (such as "Number") and the 175 numbers you need in cells A2 through A176. Make sure you save the workbook.
  2. In Word, choose Mail Merge from the Tools menu. This displays the Mail Merge Helper dialog box.
  3. Go through the steps of creating a new document consisting of labels and specifying your data source (the worksheet you created in step 1).
  4. Create the sample label so that it has the word Exhibit followed by a merge field that represents the number being pulled from the Excel worksheet. Make sure the label contents are formatted the way you need them.
  5. Merge the information to a new document. You should now have a document that has all your labels in it, and you can print them as desired.

Of course, there are third-party solutions that are available for creating sequentially numbered labels. One that comes highly recommended by several WordTips subscribers is Bates Labels from Payne Consulting (http://www.payneconsulting.com). This free Word template allows you to easily create as many labels as you need for a specific purpose.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1492) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Sequentially Numbered Labels.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Moving Captions with Pictures

Put a caption with a picture and you'd probably like the two elements to behave like they belong together. If you are tired ...

Discover More

Using a Formula to Replace Spaces with Dashes

If you need a formula to change spaces to some other character, the SUBSTITUTE function fits the bill. Here's how to use it.

Discover More

Creating One-time Labels

Need to create a set of labels for a specific purpose? The easiest way is to let Word create a set of blank labels and then ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (menu)

Picking a Starting Label

If you use the Labels feature in Word, you may want to specify which label to use as the starting point when printing. Here ...

Discover More

Changing Label Sizes

Information formatted for one type of label may someday need to be printed on a different type of label. Here's some ...

Discover More

Printing Return Address Labels

Want an easy way to create your own return address labels? Word provides the tool as a feature of the program.

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is six more than 8?

2015-03-17 14:00:10

awyatt

Keith,

As this tip says (at both the start and end), it is for older versions of Word. If you want one for your version (2010), click the links provided at both the beginning and end of this tip.

And there are images on that one!

-Allen


2015-03-17 13:50:11

Keith

What about some images. To my recollection, there is no Tools menu item in Word (office) 2010.


2015-02-06 10:58:38

Larry

To set up sequential numbers other than 1, use seq name r10 for example, on the first label starting at 10. Then use seq name
for all subsequent levels to tell it to increment by one after that first label.


2014-09-13 10:23:36

qcrank1@aol.com

I have the first page of 80, how do I proceed to the next pages? In some instances, I may need as many as 450 labels.


2014-04-04 11:50:28

Rick

if you select the field and edit field you can change the formatting etc.

# "000" will format the number to have preceding "0"
r90 will start the counting from 90

seq serial # "000" r90


2013-09-10 08:32:14

tina jungling

I have the first sheet with numbers up to 80. Now, how do you go from 80 to the next 160 for the next sheet? Once it gets to what should be 90 on the second sheet, it goes to 810 and so on. It adds a "0" to the same numbers.
help...


2013-07-24 02:19:05

Danielle

Hi,
Is there a way to use the SEQ field for numbering not from 1? I need numbering from 7000.
Thanks!


2013-06-11 13:52:23

bryn campbell

Thank you. I googled my problem & after one failed attempt I came across this advice http://word.tips.net/T001492_Sequentially_Numbered_Labels.html
It worked great. Thank you.


2013-05-25 20:37:13

Pete

My issue is trying to create small dot labels or equivalent to make up sequential alpha numeric labels to identify each individual item that I have in my shop, retrospectively. I have possibly 6-8thousand individual items that need coding for stock take purposes yet I can find no outlet that supply such thing. Do you have any suggestions. My line is antiques/collectables, predominantly china with items ranging in size from 2-3cm to 5/600cm. I would be most grateful for any solutions or suggestions. Best regards. Pete.


2013-03-14 17:53:11

Jaimie

Great tip! Worked perfectly! Thanks


2012-09-05 00:01:31

Queenie

Looks like it works only for one line message, and does not work if my label contains 2 lines, e.g. the 1st line says Trade Show items, the 2nd line says carton number 1 of 30; 2 of 30. Also can I centre it vertically?

Thanks, Queenie Sept. 5, 2012


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.