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: Excel 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
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 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...
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 Display Records that Contain a Value Between Two Values - AutoFilter.
Macro: This free Excel macro filters data to display only those records or rows that contain a va...
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Macro: This Excel macro filters data in Excel without the filter "arrow" appearing in the column ...
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...
Tutorial Details
Downloadable Files: Excel 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