Sort names alphabetically in Word

You have an employee list file as a word document. You are asked by your boss to organize the list of employees alphabetically and not sure what to do? Don't worry, the following article of TipsMake will guide you in detail how to arrange names alphabetically in Word in 3 specific cases.

1. Sort names alphabetically

Step 1 : Open the Word file containing the data table to arrange the names alphabetically, then select (black out) the name column (or any column other than the name field) that you want to sort.

Note: you can quickly select by moving the mouse to the top of the column will see a black arrow pointing down, you just need to click and select all that column.

Sort names alphabetically in Word Picture 1

Step 2 : Click the Layout tab -> Sort to open the Sort dialog box.

Sort names alphabetically in Word Picture 2

Step 3 : In Sort, you leave the default Sort by column name to sort, in My list has you select Header row if step 1 you choose the column header (Name) so Word does not sort the first cell, If you do not select the column header, then select No header row.

Next you choose the sort by name:

Ascending: sorting ascending (A-> Z).

Desending is a descending arrangement (Z-> A).

After setting up, click OK to start the arrangement.

Sort names alphabetically in Word Picture 3

So you will get the following results:

Sort names alphabetically in Word Picture 4

2. Sort your first and last name alphabetically

In case of overlapping names, you need to sort by last name, as in the above example if only sorted by name from A-> Z, Nguyen Thi Lan will stand before Nguyen Hoang Lan, but in the correct order A-> Z, Nguyễn Hoàng Lan must stand in front of Nguyễn Thị Lan because the letter H stands before the letter T. To arrange both first and last names in alphabetical order, you should do the following:

Step 1 : Select (highlight) both the First and Last names column, then select Layout -> Sort.

Sort names alphabetically in Word Picture 5

Step 2 : In the Sort dialog box, you set:

(1) choose Sort by as First Name and Then by as Last Name.

(2) select the Ascending or Descending arrangement type.

(3) In the My list has the same options above, if you select the column header, select Header row, otherwise No header row.

(4) click OK to sort by first and last name.

Sort names alphabetically in Word Picture 6

In the Sort dialog box, make settings

Your results will be as follows:

Sort names alphabetically in Word Picture 7

3. Sort names in case of column numbers

If your data table has ordinal columns, if you sort by first and last names, the ordinal columns will sort by without keeping the order from 1 to the end.So you do the following:

Step 1 : Highlight the Serial Number column and select Layout -> Sort.

Sort names alphabetically in Word Picture 8

Step 2 : In the Sort dialog box, select Options, then select Sort column only in Sort Options to set only the columns you select and click OK -> OK.

Sort names alphabetically in Word Picture 9

Step 3 : Select (black out) all columns to sort by sort by name, uncheck the column number.Next you select the Layout tab -> Sort.

Sort names alphabetically in Word Picture 10

Step 4 : In the Sort dialog box, select Sort by First Name, Then by Last Name, select the sort type and click OK to sort.At this point, only the columns you select will be sorted, and the Order Number column will remain.

Select Sort by as First Name, Then by Last Name, choose sort type and click OK to sort

Sort names alphabetically in Word Picture 11

Your results will be as follows:

Sort names alphabetically in Word Picture 12

So with the way of arranging names alphabetically in Word that TipsMake share, hope to help you solve common problems in the Word data table. Good luck!