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.