How to Sort a Name List by Same Names in MS Excel

1. Select the column of names that you would like to sort.
2. Open the 'Data' tab.
3. Under the 'Sort Filter' group, click the 'Sort A to Z' button. This button features the letter 'A' on top of the letter 'Z' on the left side, and an arrow pointing down on the right side. All of the names are now sorted alphanumerically, and cells containing the same names are right next to each other.