Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons.

The SORT function sorts the contents of a range or array. In this example, we're sorting by Region, Sales Rep, and Product individually with =SORT (A2:A17), copied across cells F2, H2, and J2.

Select the table. After you select it, the Table Design and Layout tabs will appear. Next to Table Design, go to Layout > Sort. In the dialog box, choose how you’d like to sort the table. Choose whether data …

Find solutions for Xbox account and profile issues, manage settings, and get support for your Xbox experience.

When sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data.

Sort your email messages in a way that's helpful to you. For example, sort by the name of the sender or the recipient, the date of the email message, its size, and other options. Select a tab option below for …

Sorting data is an integral part of data analysis. You might want to organize a list of names in alphabetical order or you might want to compile a list of product inventory levels from highest to lowest.

Keep your tasks organized by sorting each list: Click or tap the three dots in the top right of your list to open the more menu. Then, select Sort by and you’ll have the option to organize your list by …

You can sort a one-level bulleted or numbered list so the text appears in ascending (A to Z) or descending (Z to A) alphabetical order.

The SORTBY function sorts the contents of a range or array based on the values in a corresponding range or array. In this example, we're sorting a list of people's names by their age, in ascending order.

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. Create or delete a custom list for sorting and filling data