How to arrange names in alphabetical order in Word
When processing Word tables, especially with a data sheet with a Name, users need to sort the content alphabetically. This will make it easier for viewers to find the name and content that comes with it, instead of the data stack.
To sort names in order A> Z or vice versa, we can immediately use the Sort feature available on Word and even on Excel. The following article will guide you how to arrange names on Word with different cases.
- How to arrange names in alphabetical order in Excel
- How to arrange alphabetical order in Google Sheets
- Word 2013 Complete Guide (Part 4): Get familiar with text editing
1. Arrange names on Word in alphabetical order
Step 1:
At the Word table, highlight the Name or any column that we want to sort alphabetically.
Step 2:
Click the Layout tab and then select the Sort tool to open the Sort dialog box.
Step 3:
New interface appears. Here we will proceed to set up the following items.
Part Sort by entering the column name to sort, My list has you select Header row if step 1 you select the column header so that Word does not sort the first cell. If you do not select the column header, select No header row.
Next, select the type of arrangement if in the ascending style A> Z ABC alphabet, select all on Ascending, otherwise, choose Desending.
Finally, click OK to save and proceed to sort data.
The result of the data table has been rearranged column Full Name in alphabetical order, the remaining data columns will also automatically be sorted.
2. Arrange the same names according to ABC
In the case of the same name, we need to follow the accompanying First and Middle Name.
Step 1:
You need to highlight both the column Name and column name in the data table and then check the Layout tab and select the Sort tool .
Step 2:
In this interface we will proceed to set up items including:
- Sort by will enter the Name column in the data table.
- Then by entering the last column in the data table.
- Sorting style between Ascending or Descending.
- The My list has if you select the column header, select Header row, otherwise select No header row.
Finally click OK to sort the data.
As a result we will see the same names that will be based on the First and Middle names to sort. There are 2 students named Pham Nghia Trung and Pham Tuan Trung. When arranging both Surname and Name in order A> Z, Pham Nghia Trung will first rank.
3. Arrange names on ordered Word columns
In case the table has the entire column, if you follow the above way, the number in the cells will not be rearranged in order 1, 2, 3, . but still keep the same number with the name.
Step 1:
At the Word tab, black out the TT Number column and then select the Layout tab and select the Sort tool .
Step 2:
The Sort dialog box appears, click the Options button below.
In the Sort Options view, select Sort column only to set up the sorting of the columns you select in the Word table. Click OK.
Step 3:
Next, the user blackens all the columns to sort by but removes the TT Number column and clicks on the Layout tab and select the Sort tool.
New interface appears Sort by as Name, Then by is Last name, Select sort and click OK . Thus only the selected columns will be in the correct order and the TT number column will remain the same.
As a result, we will get the alphabetical order table including the same names.
Above is how to sort the data table. Full name in alphabetical alphabet. Depending on the case of Word tables, you can choose the appropriate arrangement.
See more:
- Create a list of tables in Word automatically
- Instructions for setting the default font in Microsoft Word
- Invaluable Word shortcuts when processing text
I wish you all success!
You should read it
- Good fb names, sum up the best fb names
- 1000 beautiful girls names for you to choose for your little princess
- Are you sure you have read the names of these 15 technology brands correctly?
- Sort names alphabetically in Excel
- Facebook name or best Facebook name combination
- How to find names in Excel
- How to arrange alphabetical order in Google Sheets
- How to arrange names in alphabetical order in Excel
May be interested
- Relax with 3 ways to print in this simple reverse orderthere is always a right way to print your documents. some inkjet printers print pages from the top, which means you have to manually reverse the print order. this is not a problem when printing only a few pages, but when you print a few hundred pages of documents then you need a trick to print them in reverse order so you can arrange them neatly.
- What is Order in ordering, buying and selling, import and export?order is a widely used english word, but not everyone understands its full meaning. this word can refer to ordering, arranging, or even a command. read the article to understand how to use order in each real-life situation.
- The order in which objects appear in Powerpointthe order in which objects appear in powerpoint. powerpoint objects are placed in the order in which you insert them, the newest added object will be at the top of the stack. but you can still arrange the order in which they appear
- How to number order in wordenter the serial number, the initial line automatically in microsoft word: you want to quickly type the number of paragraphs. in the article below, tipsmake.com will guide how to number the order and the first line automatically in the word so you can create special characters or images as the first line character.
- Fix bug where Spotify playlist order cannot be changedhave you ever found yourself unable to rearrange your spotify playlists to the order you want? it's frustrating. why make it so difficult to arrange your music the way you want?
- How to Rearrange Pages in Wordtipsmake today will show you how to rearrange the page order in microsoft word documents. although word does not support a simple way, you can still rearrange the order by giving a title to each page, or cutting content from one page to another. other than microsoft powerpoint, there is no formal way to organize pages on microsoft word.
- How to arrange images on top of each other in Wordcollating images on top of each other in word is very simple when you just need to adjust the image position in word. the article below will guide you to combine overlapping photos in word.
- Good fb names, sum up the best fb namesgood fb names, sum up the best fb names. you want to change your facebook name is impressive and interesting, but you do not know how to name facebook? here is a list of the best fb names for both men and women, sad and happy mood, funny fb names
- How to arrange notes by name or date on iPhone and iPadif 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.
- Instructions for inserting notes in the footer in Wordin order for readers to understand the content of acronyms, majors, ... in the entire text, we will often use the note feature on the page available in word.