Forum Discussion
Solved
Alphabetizing a worksheet
I am working on a 3 column worksheet (Last name, first name, and date of birth) and wanted to alphabetize it by the first column (last name). How do I do this without mixing
You can simply sort it by sorting the Last Name column from A to Z by right clicking on any cell in the column and then selecting Sort---> A to Z
You can also sort the data by different columns' priority by selecting any cell in the data and going to Data ---> Sort and then selecting the priority of column sorting.
Abdelrahman Abdou,
Certified Microsoft Excel Expert, Consultant.
Founder, Owner @ ExcelBonanza.com
http://www.excelbonanza.com/ |
https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/
Hello, right-click on any cell in the Last Name column and Select From A to Z or Z to A from Sort!
Hope this is helpful
Hope this is helpful