Forum Discussion

Copper Contributor

Nov 02, 2019

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

excel

Formulas and Functions

AAbdou
Nov 02, 2019
pdmathews13 ,
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/

AAbdou

Copper Contributor

Nov 02, 2019

pdmathews13 ,

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/