How to Sort by Column in Excel?

Select the range of data you want to sort

Go to the Data tab

Click Sort A to Z for ascending order or Sort Z to A for descending order

To sort by a specific column, click Sort

In the Sort dialog box, choose the column under Sort by

Select the sort order under Order

Check My data has headers if your range includes headers

Click OK

To sort multiple columns, click Add Level in the Sort dialog box

Choose the next column and sort order

Click OK to apply the sort

Suggested for You

Trending Today