Nov 02 2019 09:25 AM
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
Nov 02 2019 09:38 AM
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.
Nov 02 2019 10:08 AM
@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?
Nov 02 2019 11:18 AM
Nov 02 2019 11:26 AM - edited Nov 02 2019 12:31 PM
SolutionYou 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
Nov 02 2019 11:52 AM
To format data as a table, select any cell within your range, go to the Home Tab, under the Styles section select Format as Table, select a Table style, ensure that your full range of data is in the text box labeled Where is the data for your table? and choose whether your table already has headers or not by (de)selecting the box labeled My table has headers. Then, to sort alphabetically by last name, select the downward facing arrow located in your header and choose Sort A to Z.
Each time you add a new name to the bottom of your table, you will need to re-sort your list alphabetically, it will not automatically sort your list for you.
Nov 02 2019 11:26 AM - edited Nov 02 2019 12:31 PM
SolutionYou 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