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.

With built-in custom lists, you can sort data—either by days of the week or months of the year. Optionally, you can create your own custom lists to sort by any other characteristic that doesn’t sort well alphabetically—such as high, medium, and low—or S, M, L, XL.

With custom lists, you could sort this worksheet either by Delivery month or by Priority.

Sample table

Sort by days of the week or months of the year with a built-in custom list

Follow these steps:

  1. Select the columns to sort.

    Note: For the best results, each column should have a heading.

  2. In the ribbon, click Data > Sort.

    Sort button

  3. In the Sort popup window, in the Sort by drop-down, choose the column on which you need to sort.

    For example, if you want to re-sort the previous example by delivery date, under Sort by, choose delivery.

    Sort by the delivery column

  4. From the Order drop-down, select Custom List.

    Sort dialog box

  5. In the Custom Lists box, select the list that you want, and then click OK to sort the worksheet.

    Custom lists dialog box

Create your own custom list

Follow these steps to create your own custom list for sorting:

  1. In a column of a worksheet, type the values to sort by. Arrange them in the order that you want to define the sort order—from top to bottom. For example:

    Custom list example

  2. Select all of the cells in that list, and then click File > Options > Advanced.

  3. Scroll way down to the General section and click Edit Custom Lists...

    Edit Custom Lists

  4. In the Custom Lists box, click Import.

    Import a custom list

Tip: For a short list—such as High, Medium, and Low, it may be faster to enter it directly into the List entries box in the Custom Lists box.

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

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!

×