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.
Step 2 : Click the Layout tab -> Sort to open the Sort dialog box.
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.
So you will get the following results:
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.
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.
In the Sort dialog box, make settings
Your results will be as follows:
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.
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.
Step 3 : Select (black out) all columns to sort by sort by name, uncheck the column number.Next you select the Layout tab -> Sort.
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
Your results will be as follows:
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!