Sort data in Excel worksheets
Save time organizing data in your Excel worksheets using these two simple sorting methods:
Method 1 – simple ascending/descending sort
Select a range of data you would like to sort. It can be multiple rows and columns or just one column. Then on the Data tab, click on either option based on your sorting requirements.
Method 2 – sort data by specific criteria
To sort the data by specific criteria, select a range of data you would like to sort. Then on the Data tab, click on Sort and a dialogue box will open giving you the option to do a custom sort based on selected criteria. Make your selection and then hit OK.