Excel Sort Data – A to Z


I have a data consists two columns Client Name and Amount. Now I want to sort the entire data A to Z (alphabetically) in Excel.

So in order to Sort Data – A to Z (alphabetically) in Excel you have to follow the steps given below:

1. Choose the entire list

2. Go to Data Tab

3. Click on Sort Tab

4. A Sort Panel will open, select the following from the panel

1. Sort by – Client Name

2. Sort on – Values

3. Order – Largest to Smallest

5. Click on OK

6. Lastly, your data will be sorted A to Z (alphabetically) in Excel