Sorting Inventory Labels

Written by Allen Wyatt (last updated January 11, 2025)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Word in Microsoft 365


Gary notes that labels are implemented in Word using tables. He has a three-page set of labels that he uses for inventory. Each label contains a single part number. Gary needs to add new labels to the end of the document each month before printing. Given that the table has four columns and no headings, he wonders if there is a way to sort the labels in alphabetic order left-to-right and top-to-bottom.

For Gary's purposes, there are two approaches that may prove satisfactory. The first is rather simple—after adding the new information at the bottom of the table, follow these steps:

  1. Place the insertion point in one of the cells of the table.
  2. Make sure the Table Layout tab of the ribbon is displayed.
  3. In the Data group, click the Convert to Text tool. Word displays the Convert Table to Text dialog box. (See Figure 1.)
  4. Figure 1. The Convert Table to Text dialog box.

  5. Select the Paragraph Marks radio button.
  6. Click OK. Word converts the table to text, with the contents of each cell in an individual paragraph. In addition, each paragraph should still be selected.
  7. Display the Home tab of the ribbon.
  8. Click the Sort tool in the Paragraph group. Word displays the Sort Text dialog box. (See Figure 2.)
  9. Figure 2. The Sort Text dialog box.

  10. Using the controls in the dialog box, indicate the way you want the paragraphs sorted.
  11. Click on the OK button. Word sorts the paragraphs, and they should all still be selected.
  12. Display the Insert tab of the ribbon.
  13. Click the Table tool and then click Convert Text to Table. Word displays the Convert Text to Table dialog box. (See Figure 3.)
  14. Figure 3. The Convert Text to Table dialog box.

  15. Change the Number of Columns control to 4.
  16. Click on OK. Word converts the text to a table, sorted left to right and top to bottom.

This process works just fine, but understand that the only similarity between the beginning table (step 1) and the ending table (step 13) is that they have the same number of columns and rows. The height of those rows and width of those columns will be different, which means that the result may not be satisfactory for printing the labels that Gary wants.

This brings me to the second possible approach: put your inventory items in an Excel workbook and then use mail merge, in Word, to create the labels. Excel makes updating and sorting the part numbers a snap, and it doesn't take that much work to do a mail merge using the label format you want.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (5842) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, 2021, 2024, and Word in Microsoft 365.

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

Pasting a Graphic to Multiple Worksheets

Do you need to add a logo or other graphic to a bunch of worksheets? Here are a couple of short macros that can make ...

Discover More

Ensuring Proper Page Numbers for a Table of Authorities

Automatically create a Table of Authorities entry in your document, and Word might place the necessary field at the wrong ...

Discover More

Creating an AutoText List

The AUTOTEXTLIST field is one of those esoteric fields that you may know nothing about. The cool thing it does is it ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (ribbon)

Alphabetizing By Last Name

Sorting lists of names by last name is easy if they are listed in a LAST, FIRST order. But what if the names are in FIRST ...

Discover More

Controlling Sorting Order

When you sort information either in a table or the body of you document, Word follows a very specific set of rules to do ...

Discover More

Sorting Single-Column Addresses

Got a document that contains a bunch of addresses? If you want to sort the addresses, then you are in for a surprise ...

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}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. 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 3 - 0?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

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

Videos
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.