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.

How to arrange names in alphabetical order in Excel Picture 1

Step 1:

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

How to arrange names in alphabetical order in Excel Picture 2

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.

How to arrange names in alphabetical order in Excel Picture 3

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.

How to arrange names in alphabetical order in Excel Picture 4

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.

How to arrange names in alphabetical order in Excel Picture 5

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.

How to arrange names in alphabetical order in Excel Picture 6

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 .

How to arrange names in alphabetical order in Excel Picture 7

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.

How to arrange names in alphabetical order in Excel Picture 8

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.

How to arrange names in alphabetical order in Excel Picture 9

A message appears and press OK to agree.

How to arrange names in alphabetical order in Excel Picture 10

We will get the Name column as shown below.

How to arrange names in alphabetical order in Excel Picture 11

Step 4:

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

How to arrange names in alphabetical order in Excel Picture 12

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

How to arrange names in alphabetical order in Excel Picture 13

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.

How to arrange names in alphabetical order in Excel Picture 14

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.

How to arrange names in alphabetical order in Excel Picture 15

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