To sort names alphabetically in Excel is not difficult, even the steps you follow are simple. Follow the tutorial below so you quickly know how to sort names alphabetically in Excel.
When you create a spreadsheet in Excel, the content you enter will need to be arranged in alphabetical order, especially the tables with column data is First name and last name. Sort names alphabetically in Excel ie you sort alphabetically is necessary and should be done.
Sort names in Excel alphabetically
For the First and Last column, users can split the First and Last Names column, or share the same First and Last name column. Normally the first name and the last column, the arrangement of course will be simpler and faster. However, if you can still put together a column and can still reorder the normal order and still follow the general rules.
How to sort names alphabetically in Excel
1. How to sort when dividing the First and Last column separately
Suppose you need to sort the names according to the data table that has been split into the First and Last column as the image depicted below:
Step 1: At the column Student’s name -> you highlight -> then click on the tab Home -> select Sort & Filter -> select continue Custom sort.
Step 2: Sort interface appears -> here, you can edit the order alphabetically.
– Part Column choose Student’s name.
– Part Order choose A to Z -> then press OK, got it to perform.
Step 3: As a result, the First column and First name column will be rearranged by Excel in the correct alphabet.
However is the column No. will be upside down because you sort your data by Name. To re-enter No. then you simply enter the first cell is 1 -> and then drag down the next cell -> and all cells No. below will all turn into 1.
Step 4: To rearrange the number order, click the plus icon below -> select Fill Series for automatic numbering in Excel.
The result is No. will automatically re-match the rules as shown below:
2. How to sort when the First Name column is a column
It is harder to rearrange letters by first name with the First and Last names field, than you can split this column into 2 columns, First Name and First Column.
Step 1: First, you need to add a first and last name column -> click on the next column as described in the image below -> and then right click select Insert.
Step 2: The newly added column appears. You rename the newly added column to column Full name New -> and then copy the full name to this new column.
Step 3: You make the select (blacked) column Full name New -> and then press the keyboard shortcut Ctrl + H to open the interface Find and Replace.
In Find what, you enter * space -> select Replace All -> press Close to turn off the interface.
Excel message will appear -> click OK, got it to agree.
As a result you will have columns Full name New as shown below:
Step 4: You continue to black out the column Full name New -> click tab Data -> select Sort AZ as described in the photo.
Notification Sort Warning appears -> you choose as described in the image below -> and then select Sort.
In section Sort by you would choose to be Full name New -> then sort by word as well A to Z. Press OK, got it to arrange.
As a result, the content in the First name column will automatically be sorted in alphabetical order in Excel. You just need to delete the column Full name New is okay, while the STT is turned upside down, you should follow the instructions in section 1.
3. How to create filters in Excel for quick sorting
This way helps users to quickly filter and sort data faster. To do this, simply highlight the column to sort -> then select the arrow icon to bring up the fourth sorting table as shown in the image below. You can sort from A to Z or from Z to A.
So you know how Sort names alphabetically in Excel Alright then. To arrange alphabetically in Excel, you can apply one of two ways that Taimienphi.vn just introduced above. You can separate the First and Last names into two separate columns for sorting, or if left intact, create another column and perform a few more tricks that will arrange the way you like.
Similarly, if you want to Sort data on spreadsheets for other data that is not text but numbers, for example. Please refer to the implementation on Taimienphi.vn to better understand how to do it!