How to arrange names in alphabetical order in Excel

The general and basic requirement when you create a datasheet is to arrange the content in alphabetical order, especially if the data table has columns Full name, alphabetical order is necessary. This not only creates professionalism when working on Excel, but also helps viewers more easily track data.

There will be 2 cases of alphabetical name sorting: separating the Last, First or Last column name Full name. Although it will be easier to split the sorting column, if you leave it in the same column the user can still reorder the order according to the general rules. The following article will show you how to reorder names in Excel with 2 different cases.

1. How to arrange alphabetical order in Google Sheets
2. How to combine 2 columns Full name in Excel does not lose content
3. How to arrange incremental dates in Excel

1. Divide the Full and Name columns separately:

First of all we will treat the data table divided into the Last and First Name columns as shown below.

Step 1:

In the Name column, highlight and then click on the Data tab and select Sort AZ .

Step 2:

The Sort table appears to edit the order. In the Column section select Name . Continue at the Order section, select A to Z and click OK to proceed.

Step 3:

Immediately column Full name and column will be rearranged in alphabetical order. However, STT column is still overturned by sorting by Name data.

To re-enter the STT, the user needs to fill in the first box as 1, then hover over the edge of the first cell to display the plus sign. Next, click and hold the mouse and drag down the remaining cells. Thus all STT cells will be converted to 1.

Step 4:

Click on the plus sign icon below then select Fill Series . Immediately the STT column will be rearranged in the correct order. We can use this way to number columns automatically in Excel. Readers refer to the article How to number columns automatically in Excel.

2. Column and column names Generic 1 column name:

The steps to rearrange alphabetical names with a single-column case are more complex than separating two columns for sorting.

Step 1:

First, users need to add a column of Last Name and Last name by clicking on the column next to the Last and Last column and then clicking Insert .

Step 2:

A new blank column appears. Change the name of the column just created into the Name column and then copy the entire Name and Name column to the Name column.

Step 3:

Black out the Name column and press Ctrl + H to open the Find and Replace interface. At the Find what enter * section, space and select Replace All . Click Close to close the interface.

A message appears and press OK to agree.

We will get the Name column as shown below.

Step 4:

You also black out the Name column and click on the Data tab above to select Sort AZ to reorder.

Sort by will enter as Name and also sort into A to Z. Click OK to proceed.

Immediately the content in the First and Last Name column is also rearranged according to the alphabet ABC. Finally, just delete the Name column and you're done. The re-order section in the STT column we do is as above.

3. Create an Excel filter to quickly sort:

To sort faster, you just need to highlight the column to sort, then select the arrow icon to appear the sort table as shown below. You can choose to sort in ascending or descending order.

So with the above method, the user can sort the Name column alphabetically alphabetically, with 2 ways to separate columns or combine columns. This will make the Excel data sheet easier to find.

See more:

1. How to use the Match function in Excel
2. Calculation of age in Excel
3. How to use PRODUCT function in Excel