How to arrange names alphabetically in Word

In the process of importing data into a table in Word, you did not enter the names in alphabetical order, so you want to arrange the names in order from a-> z or from z-> a to easily manage data more data. Word provides you with the Sort feature to sort the data according to your wishes. If you do not know how to arrange names alphabetically, from a-> z, please refer to the following article.

How to arrange names alphabetically in Word Picture 1

The following article shows you how to sort names alphabetically, how to arrange both first and last names alphabetically, how to sort names alphabetically without changing column numbers.

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.

How to arrange names alphabetically in Word Picture 2

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

How to arrange names alphabetically in Word Picture 3

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:

  1. Ascending : sorting ascending (A-> Z).
  2. Desending is a descending arrangement (Z-> A).

After setting up, click OK to start the arrangement.

How to arrange names alphabetically in Word Picture 4

So you will get the following results:

How to arrange names alphabetically in Word Picture 5

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

How to arrange names alphabetically in Word Picture 6

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

  1. (1) choose Sort by as First Name and Then by as Last Name .
  2. (2) select the Ascending or Descending arrangement type .
  3. (3) In the My list has the same options above, if you select the column header , select Header row, otherwise No header row.
  4. (4) click OK to sort by first and last name.

How to arrange names alphabetically in Word Picture 7

Your results will be as follows:

How to arrange names alphabetically in Word Picture 8

Sort names in the 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.

How to arrange names alphabetically in Word Picture 9

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.

How to arrange names alphabetically in Word Picture 10

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

How to arrange names alphabetically in Word Picture 11

Step 4 : In the dialog box Sort you select Sort by that name , Then by the They , select the type of arrangement and press OK to sort. At this point, only the columns you select will be sorted, and the Order Number column will remain.

How to arrange names alphabetically in Word Picture 12

Your results will be as follows:

How to arrange names alphabetically in Word Picture 13

So with the way to arrange alphabetically in Word that the article shares, hope to help you solve common problems in the Word data table. Good luck!

4 ★ | 2 Vote

May be interested

  • How to arrange notes by name or date on iPhone and iPadHow to arrange notes by name or date on iPhone and iPad
    if you don't want ios to categorize your notes by editing date, you can customize them by title or date created on iphone or ipad from ios 11 and above. follow these steps to arrange notes as you like.
  • How to Sort Excel Columns AlphabeticallyHow to Sort Excel Columns Alphabetically
    microsoft excel is a great tool for organizing data. this article will introduce to you a simple but extremely useful feature, which is sorting data in alphabetical order.
  • How to insert Clip Art in Word 2003, 2007 simply and quicklyHow to insert Clip Art in Word 2003, 2007 simply and quickly
    clip art is a collection of illustrations available in microsoft word, making the text more vivid and intuitive. in word 2003 and 2007, users can easily insert clip art using the insert clip art tool, edit and arrange the image appropriately.
  • Facebook name or best Facebook name combinationFacebook name or best Facebook name combination
    here is a summary of good facebook names, facebook names with sad mood, unique funny facebook names, japanese names, cool sword names, long and frantic names ... you can freely choose according to my hobbies, my moods.
  • How to arrange names in alphabetical order in ExcelHow to arrange names in alphabetical order in Excel
    a complete and correct excel table if you have a product name or a full name is added to the alphabetical order. so how to name in alphabetical order on excel?
  • How to find names in ExcelHow to find names in Excel
    how to find names in excel. you have a long list of hundreds and thousands of names, you are looking for ways to find names in excel to help save time when processing data. so invite you to learn how to find names in excel that tipsmake.com share below.
  • 1000 beautiful girls names for you to choose for your little princess1000 beautiful girls names for you to choose for your little princess
    the following 1000 names are arranged in alphabetical order, you can consult, learn and choose for your baby the names including the best middle name.
  • How to arrange the Icon icon on the DesktopHow to arrange the Icon icon on the Desktop
    arranging the icons on the desktop in a neat and organized manner will help you can easily find the application you need to open and look at the computer screen. tipsmake.com will guide you some ways to arrange icons on m
  • Customize toolbars in WordCustomize toolbars in Word
    customize the toolbars in word, normally, the word editing window usually has three standard toolbars with the following names
  • How to rotate a table in Word (Rotate a table 90 degrees in Word)How to rotate a table in Word (Rotate a table 90 degrees in Word)
    in text presentation, sometimes you want to arrange your word tables to rotate 90 degrees so that you can present your text better. tipsmake.com will guide you how to rotate tables in word with many different methods.