How to Sort Labels in Word

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Sorting labels doesn't have to be laborious. If you have an existing data source file, you can sort them before they are printed. The source file is the list containing the information you want to pull, created in Word, a spreadsheet, database or address book. If you use it in combination with a mail merge, you'll have the option to sort up to three fields in ascending or descending order. Any modifications you make are applied to your labels.

Advertisement

Step 1

Start a new document in Word 2007.

Video of the Day

Step 2

Select the "Mailings" tab. Click "Start Mail Merge" and "Step by Step Mail Merge Wizard."

Step 3

Select "Labels" in the Mail Merge task pane. Click "Next."

Advertisement

Step 4

Click "Use the current document" or "Start from existing document." To modify the current document, select "Label options," choose your label settings and click "OK." To modify an existing document, click "More files," double-click the file you need and click "Next."

Advertisement

Step 5

Select "Use an existing list" and click "Browse."

Step 6

Double-click the data source file containing your label content (such as names and mailing addresses). Go to the "Refine recipient list" section in the "Mail Merge Recipients" dialog box and click "Sort."

Advertisement

Step 7

Select the "Sort Records" tab in the "Filter and Sort" dialog box.

Advertisement

Step 8

Click the pull-down menu beside "Sort by" and select the first field (in priority order) you wish to sort. Choose "Ascending" or "Descending."

Advertisement

Step 9

Click the pull-down menu beside "Then by" and select the next field you wish to sort, in priority order. Choose "Ascending" or "Descending." To sort a third field, go to the next "Then by" option, choose your sorting preferences and click "OK."

Advertisement

Step 10

Click "OK" to close the "Mail Merge Recipients" dialog box.

Step 11

Click "Next: Arrange your labels."

Step 12

Click "More items" to open the "Insert Merge Field" dialog box. Double-click any fields you want to add to the label and click "Close."

Advertisement

Step 13

Go to the label sheet and arrange each field the way it should appear on the label. For example, you can insert a space between the first and last name.

Advertisement

Step 14

Return to the task pane and click "Update all labels."

Advertisement

Step 15

Select "Next: Preview your labels."

Step 16

Select "Next: Complete the merge."

Step 17

Select "Print" or "Edit individual letters." Click "OK" in the "Merge to Printer" or "Merge to New Document" dialog box to complete the merge for your sorted labels.

Video of the Day

Advertisement

Advertisement

references

Report an Issue

screenshot of the current page

Screenshot loading...