Related topics
×
Sort and filter data
Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Sort and filter data

Sort data

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sort data in Excel quickly, in just a few clicks. To change the order of your data, sort it. To focus on a specific set of data, filter a range of cells or a table.

Select the data that you want to sort

  • Select a range of data, such as A1:L5 (multiple rows and columns), or C1:C80 (a single column). The range can include titles (headers) that you create to identify columns or rows.

Sort quickly

  1. Select a single cell in the column you want to sort.

  2. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest).

  3. Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest).

Want more?

Sort by dates

Sort data using a custom list

Filter data in a range or table

Excel is an amazing tool for analyzing data.

And Sort and Filter are some of the most commonly used features to help you do this.

To change the order of your data, you’ll want to sort it.

Right-click a cell in the column you want to sort, and point to Sort.

Since the cells in this column contains only numbers, the sort options are Sort Smallest to Largest, and Sort Largest to Smallest.

Most number formats, such as Time and Currency, have the these sort options.

I click Sort Smallest to Largest, and the codes are sorted from lowest to highest value.

To focus on a specific set of your data, you can filter a range of cells or a table.

Click any cell in the range or table. On the HOME tab, click Sort & Filter, and click Filter.

Click a drop-down arrow at the top of one of the columns to display its filter options.

I click the drop-down arrow in the Category column.

Since the column contains text I get the Text Filters options. I can also uncheck and check values.

I uncheck all values, select Fruit, and click OK. And only the rows that have Fruit in the Category column are displayed.

Up next, Sort details.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×