Organize Data in Excel with Custom Lists

Add to Favorites
Author:

Quick and simple way to sort and order your data in a custom order using a custom set of data (a list).

This also allows you to quickly generate custom pre-programmed lists in Excel.

Here you learn:

  • How to make a custom list in Excel.
  • How to sort data in a custom order.
  • How to apply custom lists to data sets.
  • How to edit custom lists.
  • How to delete custom lists.

Resources

Custom Excel List (Msft)


Downloadable Files: Project File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Streamline Repetitive Tasks in Excel with AI Data Cleaning & ChatGPT
Tutorial: How to clean your data in Excel using ChatGPT and AI to build custom macros and VBA. This...
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Macro: This Excel macro filters data in Excel to display results that contain 1 of 2 possible val...
Guide to Combine and Consolidate Data in Excel
Tutorial: Guide to combining and consolidating data in Excel. This includes consolidating data from ...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
Filter Data in Excel - AutoFilter
Macro: This free Excel macro filters data in Excel using the autofilter feature in an Excel macro...
Tutorial Details
Downloadable Files: Project File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course