Instructions for sorting names alphabetically in Excel


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:

Guide to copy the data according to the letters in Excel 2

Step 1: At the column Student’s name -> you highlight -> then click on the tab Home -> select Sort & Filter -> select continue Custom sort.

Guide to sort by alphabetical format in Excel 3

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.

Guide to copy the data according to the letters in Excel 4

Step 3: As a result, the First column and First name column will be rearranged by Excel in the correct alphabet.

Guide to sort according to the letters in Excel 5

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.

Guide to sort according to the letters in Excel 6

Step 4: To rearrange the number order, click the plus icon below -> select Fill Series for automatic numbering in Excel.

Guide to sort according to the letters in Excel 7

The result is No. will automatically re-match the rules as shown below:

Guide to follow the standard letters in Excel 8

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.

Guide to sort by alphabetical format in Excel 9

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.

Guide to follow the standard letters in Excel 10

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.

Guide to setting the number according to the word format in Excel 11

Excel message will appear -> click OK, got it to agree.

Guide to sort according to the letters in Excel 12

As a result you will have columns Full name New as shown below:

Guide to setting the number according to the word format in Excel 13

Step 4: You continue to black out the column Full name New -> click tab Data -> select Sort AZ as described in the photo.

Guide to setting the number according to the word format in Excel 14

Notification Sort Warning appears -> you choose as described in the image below -> and then select Sort.

Guide to follow the standard letters in Excel 15

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.

Guide to follow the standard letters in Excel 16

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.

Guide to setting the number according to the letters in Excel 17

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.

Guide to follow the standard letters in Excel 18

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.

https://thuthuat.taimienphi.vn/huong-dan-sap-xep-ten-theo-thu-tu-chu-cai-in-excel-47219n.aspx
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!

.

Add a Comment

Your email address will not be published. Required fields are marked *