Custom sorting rules in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a custom sort in Excel?

A custom sort lets you arrange data in an order you choose, not just alphabetical or numerical. For example, sorting days of the week in their natural order instead of A-Z.

intermediate

How do you create a custom list for sorting in Excel?

Go to File > Options > Advanced > Edit Custom Lists. Then type your list items in order, separated by commas or one per line, and add it. This list can be used to sort data in that specific order.

beginner

Why use custom sorting instead of normal sorting?

Normal sorting arranges data alphabetically or numerically. Custom sorting lets you sort by your own rules, like sorting priority levels (High, Medium, Low) or months in calendar order.

beginner

What steps do you follow to apply a custom sort to a column in Excel?

1. Select your data. 2. Go to Data tab > Sort. 3. Choose the column to sort. 4. Under Order, select Custom List. 5. Pick your custom list and click OK.

intermediate

Can you use custom sorting with multiple columns in Excel?

Yes! You can add levels in the Sort dialog to sort by one column first, then by another. Each column can use its own custom list if needed.

What does a custom sort in Excel allow you to do?

A Sort data in any order you define

B Only sort data alphabetically

C Sort data by color only

D Sort data randomly

Custom sort lets you define your own order, like sorting days or priority levels.

Where do you add a custom list for sorting in Excel?

A Home tab > Format

B File > Options > Advanced > Edit Custom Lists

C Data tab > Sort

D Insert tab > Table

Custom lists are created in Excel Options under Advanced settings.

Which of these is an example of a good use for custom sorting?

A Sorting months in calendar order

B Sorting numbers from smallest to largest

C Sorting text alphabetically

D Sorting by cell color

Months don’t sort correctly alphabetically, so custom sorting fixes that.

How do you apply a custom sort to a column?

A Insert a new column and sort manually

B Right-click and choose Sort > Custom

C Use Home > Sort & Filter > Custom

D Use Data > Sort, select column, then choose Custom List

The Sort dialog under Data tab lets you pick custom lists for sorting.

Can you sort by multiple columns using custom lists?

A Only if columns have numbers

B No, only one column at a time

C Yes, by adding levels in the Sort dialog

D Only if columns have dates

Excel allows multiple levels of sorting, each with its own custom list if needed.

Explain how to create and use a custom sort list in Excel.

Think about where Excel stores your custom order and how you apply it.

Describe a real-life example where custom sorting is helpful.

Consider lists that don’t follow alphabetical or numeric order.