Excel - Create a custom list to sort data

Posted on:  12/03/2021
Excel - Create a custom list to sort data

Excel makes it easy to sort using built-in custom lists, you can sort data—either by days of the week or months of the year. I'll demonstrate how to 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, or fiscal months of July to June or October to September. You can create a custom sort list for products or regions.

Excel Custom Sort List

Excel Custom Sort List

YouTube video

Other Excel articles

Create a custom sort list PC/Windows

  1. In a column of a worksheet, type the values to sort by.
  2. Arrange them in the order that you want to define the sort order—from top to bottom.
  3. Select all of the cells in that list, and then click File - Options - Advanced.
  4. Scroll way down to the General section and click Edit Custom Lists...
  5. In the Custom Lists box, click Import.
  6. Click OK twice.
File - Options - Advanced - Edit Custom List in Excel

File - Options - Advanced - Edit Custom List in Excel

Import custom list - fiscal months example

Import Custom List in Excel

The example is Fiscal Months Jul to Jun

Create a custom sort list - Mac

  1. On the Excel menu, click Preferences, and then under Formulas and Lists, click Custom Lists .
  2. Click Add.
  3. Type the values for your list in the order that you want them sorted, with a comma between each value.
  4. When you are finished, click Add, and then close the Custom Lists box.

Microsoft support article for Mac https://support.microsoft.com/en-us/office/sort-a-list-of-data-in-excel-for-mac-3b0e62c1-ef88-4176-babb-ccf1cb1e6145

Other Recent Excel articles

Mastering Excel Slicers: A Comprehensive Guide

Mastering Excel Slicers: A Comprehensive Guide

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Social Security - Breakeven point in Years using Excel

Social Security - Breakeven point in Years using Excel

Other Recent Teams articles

Microsoft Teams: How to Add Your Name Pronunciation (NEW Feature - December 2024)

Microsoft Teams: How to Add Your Name Pronunciation (NEW Feature - December 2024)

Exploring the New Chat & Channels Experience in Microsoft Teams

Exploring the New Chat & Channels Experience in Microsoft Teams

Navigating the New Microsoft Teams Refreshed View: A Comprehensive Guide

Navigating the New Microsoft Teams Refreshed View: A Comprehensive Guide

Copilot in Teams Control Access: Manage Recordings, Transcriptions & AI Insights

Copilot in Teams Control Access: Manage Recordings, Transcriptions & AI Insights

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories