How to Custom Sort in Excel

Learn how to do Custom Sort in MS Excel, discover the shortcuts to create custom lists and to Custom Sort like a pro.

Learn how to do Custom Sort in Excel and sort data with ease: save time and impress your colleagues with these Excel tips and tricks.

Sort only the range of cells you want, without changing the order of other columns!

Become proficient in MS Excel with Ted Jordan, at your own pace.

Ready to learn how to use Excel Custom Sort feature?

Custom Sort lists are great to sort in a user-defined order: you can create your own list based on text, for example.

In Excel, there are some custom lists already built by the system: day-of-the-week and month-of-the-year lists such as Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec.

Sort only the range of cells you want by following the steps below:

Start by selecting the cells you want to sort.

In this example, we only want to sort columns B to E. We don’t wish to change the order of column A.

We want to know in which order we should use our ads to save money and increase sales (our KPI is CPL, the cost per lead).

Cells B50 to E53 are selected in Excel.

In Home, select Sort & Filter then click Custom Sort

If you selected the headers, you will find them under Column. If you haven’t (like in this situation), untick “My list has headers”.

Select the column you want to sort.

In this example, it’s column E (as a reminder, CPL is our KPI).

Make sure Sort on and Order are correct then click OK.

Now, columns B to E are sorted and we know in which order we need to use our ads to save money and increase sales.

Columns B to E are sorted and column A did not change as expected.

The Custom Sort shortcut is Command+Shift+R in MS Excel.

If you wish to create your own custom list, continue to read our Excel tutorial.

There are two ways to create Custom Sort lists in Microsoft Excel; today we’ll show you our favourite and we will explain how custom lists are stored.

To create a custom list in Excel, follow the steps below:

First, enter your list in an Excel Sheet with the order of sorting preference then press Command+,

Now, select Custom Lists.

The Custom Lists window opens: it’s time to import your list from cells.

Click the cells selection section, select the cells with your Custom Sort list and click Import.

Finally, close the window. You have now created your own Custom Sort list in Excel!

To use the Custom Sort list you just have created, in Excel, select the data you want to sort, press Command+Shift+R and select your custom list in the Order section.

Example

In this example, we want to sort our tasks list by priority order. The priority order follows our Custom Sort list: Urgent, Medium, Low, TBC.

We select our data, press Command+Shift+R then select Priority under Column and click Custom List… under Order.

We then select our own Custom Sort list and click OK.

Now, we know in which order we should prioritise our asks: we have to finish tasks B and E as soon as possible.

Custom Sort lists are stored in your Excel workbooks. If you use the custom list to sort data, then you will be able to select the custom list in the same workbook, from another computer.

Note that the Custom Sort list will not appear in the Custom Lists section when pressing Command+, but will be available for selection under Order in the Custom Sort window.

Can Custom Sort lists be used on other workbooks?

If you open other workbooks from the same computer you created and saved your Custom Sort lists, you will be able to use your lists.

Now, you know how to do Custom Sort in Excel like a professional. You also discovered the shortcuts to find Custom Lists and to Custom Sort…

Time to get MS Excel certified!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a specialist. Go from programmatic dummy to programmatic expert.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Programmatic Acronyms: 44 Terms to Know

Learn what these 44 Programmatic Advertising acronyms mean to understand what your colleagues or customers are saying when they use it. Explained with simple words, by Ted Jordan, for Digital...

Read More

Categories

AllFunctionsToolsShortcut Keys
Split Semicolon Separated Value in Excel

How to split semicolon separated values in Excel

Split semicolon separated values in Excel into columns and rows, or convert columns to semicolon separated values, like an Excel Master!

Read More

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More
Absolute Referencing in Excel

Locking cells: what’s the Excel dollar sign shortcut?

The Excel absolute reference shortcut will become one of your favourites to save time! Switch from relative to absolute references in seconds using this trick.

Read More
Using Text to Column to Extract texts on Excel

Excel: How to split text into columns

If you need to extract data in Excel, you may want to use the Text to Columns tool. With only 3 steps, it's really easy to split text into columns.

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More