Forum Discussion
Alphabetizing a worksheet
- Nov 02, 2019
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 pdmathews13,
When you say "How do I do this without mixing" do you mean, how do I sort while keeping the order across rows intact?
If so, I recommend selecting all of your data in these three columns and formatting the data as a table. Once the data is formatted as a table, you may then sort the data by Last Name while keeping the correct first name and DOB intact.
- pdmathews13Nov 02, 2019Copper Contributor
PReagan How do I do that? Also, will it automatically put new names entered in the right place or do I just need to wait until I am done adding names?