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/
How do I format as a table?
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.